Oracle 导入dmp文件命令

1. 导入dmp 文件OEM_PART_CAR 表

imp "'test/test@orcl as sysdba'" file=F:\0708.dmp buffer=30720 commit=no full=no grants=yes ignore=yes indexes=yes rows=yes show=no 
constraints=yes TABLES=(table1,table2) log=D:\epc.log

table1 和 table2 为导入的目标表名称

2. 表空间设置大小和自动扩展

 select tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name = 'SYSTEM';
 

 alter tablespace SYSTEM  add datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM02.DBF' size 4194303; 

http://gqsunrise.iteye.com/blog/2015692  Oracle修改表空间为自动扩展
alter database datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM02.DBF' autoextend on;
File size (8960000 blocks) exceeds maximum of 4194303 blocks

3. 删除表SQL

1  drop table table;--删除表
2 
3  purge recyclebin;--清除回收站
4 
5  TRUNCATE TABLE table; --删除表

 

转载于:https://www.cnblogs.com/bjwl/p/5577325.html