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.
标签：Execute,used,dimpdp,time,ms,SQL,dexpdp,id,达梦 From： https://www.cnblogs.com/orcl-2018/p/16593906.html