Create table spaces, users, directories, import \ Export files, and more from the Oracle database

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

Imp 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% ' \";

Or

Exp HB/HB file= file path \xxx.dmp;

Original link: http://www.cnblogs.com/wush-2015/p/4499424.html

Create table spaces, users, directories, import \ Export files, and more from the Oracle database