增加表空间大小及imp、impdp、sqlldr导入命令

imp导入

imp mydata/XXX@orcl file=F:\.dmp full=y ignore=y buffer=100000000

创建表空间

create tablespace mydata datafile 'F:/app/oracle_tXXXXXXablespaces/TAXI_GPS_TBSPACE.dbf' size 1500M autoextend on next 5m maxsize unlimited;

修改数据文件大小

alter database datafile 'F:/app/oracle_tablespaces/TAXI_GPS_TBSPACE.dbf' autoextend on next 5m maxsize unlimited;

增加数据文件

alter tablespace mydata add datafile 'F:/app/oracle_tablespaces/TAXI_GPS_TBSPACE1.dbf' size 30048m autoextend on next 5m maxsize unlimited;

删除表空间和数

DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;

impdp导入

impdp mydata/mydata@orcl dumpfile=TAXI_GPS_20150506.dmp logfile=TAXI_GPS_20150506.log

sqlldr 导入

sqlldr userid=mydata/mydata@orcl control='E:\taxi_gps_20150508.ctl' log='E:\taxi_gps_20150508.log' 

C:\Users\Administrator> sqlldr userid=mydata/mydata@orcl control='E:\taxi_gps_20150510.ctl' log='E:\taxi_gps_20150510.log' skip=1 readsize=10485760