1. CREATE TABLE Space
Create Tablespace Ts_aw
Logging
DataFile ' d:\app\Administrator\product\tablespace\ts_aw.dbf '
Size 10M
Autoextend on
Next 5M
MaxSize 20480M;
2. Create user
Create user HB identified by HB
Default Tablespace Ts_aw;
3, to the user authorization limit
Grant CONNECT,RESOURCE,DBA to HB;
4. Create a Directory
Create or replace directory Data_pump_dir as
' E:\data_pump_dir ';
Grant Read,write on directory Data_pump_dir to HB;
Grant Exp_full_database,imp_full_database to HB;
Exit
5. Import files
IMPDP Userid=hb/[email protected] file=f:\c3\project\tzhb\hb.dmp full=y;
Or
IMPDP HB/HB Directory=data_pump_dir
DUMPFILE=GTS.MP Table_exists_action=append
Data_options=skip_constraint_errors nologfile=y;
6. Export File
EXPDP HB/HB Directory=data_dump_dir dumpfile=hb.dmp
Logfile=hb.log
Compression=all SCHEMAS=HB include=table: "\like ' gt% ' \";
Create table spaces, users, directories, import \ Export files, and more from the Oracle database