1.创建directory
SQL> create directory direct as '/dm8/direct';
executed successfully
used time: 48.272(ms). Execute id is 503.
2.创建测试用户
SQL> create user tt identified by passwordfortt default tablespace tt;
executed successfully
used time: 27.299(ms). Execute id is 509.
SQL> grant create session to tt;
executed successfully
used time: 2.199(ms). Execute id is 510.
SQL>
SQL> grant resource to tt;
executed successfully
used time: 2.183(ms). Execute id is 511.
SQL> grant read,write on directory direct to tt;
executed successfully
used time: 2.403(ms). Execute id is 512.
3.创建测试表
[dmdba@node01 ~]$ disql tt/passwordfortt
Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 1.460(ms)
disql V8
SQL>
SQL> create table test (id number(10),name varchar2(10));
executed successfully
used time: 178.871(ms). Execute id is 600.
SQL>
SQL>
SQL> insert into test values (1,'jack');
affect rows 1
used time: 0.773(ms). Execute id is 601.
SQL>
SQL> insert into test values (2,'lucy');
affect rows 1
used time: 0.322(ms). Execute id is 602.
SQL> insert into test values (3,'scott');
affect rows 1
used time: 0.575(ms). Execute id is 603.
SQL>
SQL> commit;
executed successfully
used time: 0.809(ms). Execute id is 604.
SQL>
SQL> select * from test;
LINEID ID NAME
---------- -- -----
1 1 jack
2 2 lucy
3 3 scott
used time: 0.817(ms). Execute id is 605.
4.导出test表数据
[dmdba@node01 ~]$ dexpdp tt/passwordfortt directory=DIRECT file=test.dmp log=test.log tables=tt.test
dexpdp V8
---- [2022-08-17 09:16:16]export table:TEST -----
the privilege of the object at the export mode...
table :TEST export terminate, total export 3 rows
all the export process spent total 0.078 s
terminate export success without warning
5.把test表改名为test1
SQL> alter table test rename to test1;
executed successfully
used time: 48.299(ms). Execute id is 606.
6.导入数据
[dmdba@node01 ~]$ dimpdp tt/passwordfortt directory=DIRECT file=test.dmp log=impdp_test.log
dimpdp V8
local code: PG_UTF8, dump file code: PG_UTF8
----- [2022-08-17 09:18:47]import table:TEST -----
create table TEST
import table TEST , has coped with 3 rows
all the import process spent total 0.022 s
terminate import success without warning
7.验证
[dmdba@node01 ~]$ disql
disql V8
username:tt
password:
Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 1.466(ms)
SQL>
SQL>
SQL> select table_name from user_tables;
LINEID TABLE_NAME
---------- ----------
1 TEST1
2 TEST
used time: 13.752(ms). Execute id is 7200.
SQL> select * from test;
LINEID ID NAME
---------- -- -----
1 1 jack
2 2 lucy
3 3 scott
used time: 0.817(ms). Execute id is 7201.
