GaussDB T 支持EXP/IMP导出导入数据，本文介绍如果通过EXP/IMP迁移用户及数据。
1、exp导出数据：
命令：exp users=steven file=“steven.dmp”;
[omm@pr7 ~]$ zsql / as sysdba -q
connected.
SQL> exp -h;
The syntax of logic export is:
Format: EXP KEYWORD=value or KEYWORD=value1,value2,...,valueN;
Example: EXP TABLES=EMP,DEPT,MGR;
or EXP USERS=USER_A,USER_B;
or EXP DIST_RULES=RULE_1,RULE_2;
Keyword Description (Default)
---------------------------------------------------------------------------------------------------------------------------
USERS List of schema names. Specify a percent sign (%) to export all users.
TABLES List of table names. Specify a percent sign (%) to export all tables.
DIST_RULES List of distribute rule names. Specify a percent sign (%) to export all distribution rules. Supported only for sharding.
TABLESPACE_FILTER List of tablespace names, the data or objects in these tablespaces will be exported. Case-sensitive words enclosed by '`' or '"'.
FILE Output file (EXPDAT.DMP)
FILETYPE Output file type: (TXT), BIN
LOG Log file of screen output
COMPRESS Compress output file (0), only for FILETYPE=BIN, values is 0~9, litter for faster compress speed, 0 is not compressed.
CONTENT Specifies data to unload where the valid keyword, values are: (ALL), DATA_ONLY, and METADATA_ONLY.
QUERY Predicate clause used to export a subset of a table, eg. "where rownum <= 10"
SKIP_COMMENTS Do not add comments to dump file. (N)
FORCE Continue even if an SQL error occurs during a table dump. (N)
SKIP_ADD_DROP_TABLE Do not add a DROP TABLE statement before each CREATE TABLE statement. (N)
SKIP_TRIGGERS Do not dump triggers. (N)
QUOTE_NAMES Quote identifiers. (Y)
TABLESPACE Default transport all tablespaces except for system reserved. (N)
COMMIT_BATCH Batch commit rows, commit once if set 0. (1000)
INSERT_BATCH Batch insert rows. (1)
FEEDBACK Feedback row count, feedback once if set 0 (10000)
PARALLEL Table data export parallelism settings, range 2~32, The default value is 0
CONSISTENT Cross - table consistency(N)
CREATE_USER Export user definition(N),Used in conjunction with USERS.
ROLE Export user roles expect system preset roles (N),Used in conjunction with USERS.
GRANT Grant role and pemission to USER (N),Used in conjunction with USERS and ROLE.
WITH_CR_MODE Export tables and indexes with CR_MODE options (N)
SQL> exp users=steven file="steven.dmp";
Parsing export options ...
Verify options ...
verify schema ...
Starting export ...
Preparing to export ...
-- EXPORT TYPE = SCHEMA
-- EXPORT OBJECTS = STEVEN
-- FILE TYPE = TXT
-- DUMP FILE = steven.dmp
-- LOG FILE =
-- QUERY = ""
-- COMPRESS = N
-- CONSISTENT = N
-- CONTENT_MODE = ALL
-- SKIP_COMMENTS = N
-- FORCE = N
-- SKIP_ADD_DROP_TABLE = N
-- SKIP_TRIGGERS = N
-- QUOTE_NAMES = Y
-- TABLESPACE = N
-- COMMIT_BATCH = 1000
-- INSERT_BATCH = 1
-- FEEDBACK = 10000
-- PARALLEL = 0
-- CREATE_USER = N
-- ROLE = N
-- GRANT = N
-- WITH_CR_MODE = N
Exporting schema STEVEN ...
Exporting sequence of schema STEVEN ...
Exporting tables of schema STEVEN ...
Reading table objects of STEVEN
The order of exporting table is:
TABLE NAME LEVEL
---------------------------------------------------------------- ----------
STEVEN_TEST 1
BMSQL_CONFIG 2
BMSQL_WAREHOUSE 3
BMSQL_DISTRICT 4
BMSQL_CUSTOMER 5
BMSQL_HISTORY 6
BMSQL_NEW_ORDER 7
BMSQL_OORDER 8
BMSQL_ORDER_LINE 9
BMSQL_ITEM 10
BMSQL_STOCK 11
REGIONS 12
COUNTRIES 13
LOCATIONS 14
DEPARTMENTS 15
JOBS 16
EMPLOYEES 17
JOB_HISTORY 18
Exporting tables (scripts or data) of STEVEN
exporting table STEVEN.STEVEN_TEST ...
exporting DDL of STEVEN.STEVEN_TEST ...
exporting data of STEVEN.STEVEN_TEST ...
data exporting success, 20 rows are dumped.
exporting indexes on STEVEN.STEVEN_TEST ...
exporting constraints on STEVEN.STEVEN_TEST ...
exporting table STEVEN.BMSQL_CONFIG ...
exporting DDL of STEVEN.BMSQL_CONFIG ...
exporting data of STEVEN.BMSQL_CONFIG ...
data exporting success, 4 rows are dumped.
exporting indexes on STEVEN.BMSQL_CONFIG ...
exporting constraints on STEVEN.BMSQL_CONFIG ...
exporting table STEVEN.BMSQL_WAREHOUSE ...
exporting DDL of STEVEN.BMSQL_WAREHOUSE ...
exporting data of STEVEN.BMSQL_WAREHOUSE ...
data exporting success, 10 rows are dumped.
exporting indexes on STEVEN.BMSQL_WAREHOUSE ...
exporting constraints on STEVEN.BMSQL_WAREHOUSE ...
exporting table STEVEN.BMSQL_DISTRICT ...
exporting DDL of STEVEN.BMSQL_DISTRICT ...
exporting data of STEVEN.BMSQL_DISTRICT ...
data exporting success, 100 rows are dumped.
exporting indexes on STEVEN.BMSQL_DISTRICT ...
exporting constraints on STEVEN.BMSQL_DISTRICT ...
exporting table STEVEN.BMSQL_CUSTOMER ...
exporting DDL of STEVEN.BMSQL_CUSTOMER ...
exporting data of STEVEN.BMSQL_CUSTOMER ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
100000 rows are dumped.
110000 rows are dumped.
120000 rows are dumped.
130000 rows are dumped.
140000 rows are dumped.
150000 rows are dumped.
160000 rows are dumped.
170000 rows are dumped.
180000 rows are dumped.
190000 rows are dumped.
200000 rows are dumped.
210000 rows are dumped.
220000 rows are dumped.
230000 rows are dumped.
240000 rows are dumped.
250000 rows are dumped.
260000 rows are dumped.
270000 rows are dumped.
280000 rows are dumped.
290000 rows are dumped.
300000 rows are dumped.
data exporting success, 300000 rows are dumped.
exporting indexes on STEVEN.BMSQL_CUSTOMER ...
exporting constraints on STEVEN.BMSQL_CUSTOMER ...
exporting table STEVEN.BMSQL_HISTORY ...
exporting DDL of STEVEN.BMSQL_HISTORY ...
exporting data of STEVEN.BMSQL_HISTORY ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
100000 rows are dumped.
110000 rows are dumped.
120000 rows are dumped.
130000 rows are dumped.
140000 rows are dumped.
150000 rows are dumped.
160000 rows are dumped.
170000 rows are dumped.
180000 rows are dumped.
190000 rows are dumped.
200000 rows are dumped.
210000 rows are dumped.
220000 rows are dumped.
230000 rows are dumped.
240000 rows are dumped.
250000 rows are dumped.
260000 rows are dumped.
270000 rows are dumped.
280000 rows are dumped.
290000 rows are dumped.
300000 rows are dumped.
310000 rows are dumped.
320000 rows are dumped.
data exporting success, 329908 rows are dumped.
exporting indexes on STEVEN.BMSQL_HISTORY ...
exporting constraints on STEVEN.BMSQL_HISTORY ...
exporting table STEVEN.BMSQL_NEW_ORDER ...
exporting DDL of STEVEN.BMSQL_NEW_ORDER ...
exporting data of STEVEN.BMSQL_NEW_ORDER ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
data exporting success, 93068 rows are dumped.
exporting indexes on STEVEN.BMSQL_NEW_ORDER ...
exporting constraints on STEVEN.BMSQL_NEW_ORDER ...
exporting table STEVEN.BMSQL_OORDER ...
exporting DDL of STEVEN.BMSQL_OORDER ...
exporting data of STEVEN.BMSQL_OORDER ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
100000 rows are dumped.
110000 rows are dumped.
120000 rows are dumped.
130000 rows are dumped.
140000 rows are dumped.
150000 rows are dumped.
160000 rows are dumped.
170000 rows are dumped.
180000 rows are dumped.
190000 rows are dumped.
200000 rows are dumped.
210000 rows are dumped.
220000 rows are dumped.
230000 rows are dumped.
240000 rows are dumped.
250000 rows are dumped.
260000 rows are dumped.
270000 rows are dumped.
280000 rows are dumped.
290000 rows are dumped.
300000 rows are dumped.
310000 rows are dumped.
320000 rows are dumped.
330000 rows are dumped.
data exporting success, 330678 rows are dumped.
exporting indexes on STEVEN.BMSQL_OORDER ...
exporting constraints on STEVEN.BMSQL_OORDER ...
exporting table STEVEN.BMSQL_ORDER_LINE ...
exporting DDL of STEVEN.BMSQL_ORDER_LINE ...
exporting data of STEVEN.BMSQL_ORDER_LINE ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
100000 rows are dumped.
110000 rows are dumped.
120000 rows are dumped.
130000 rows are dumped.
140000 rows are dumped.
150000 rows are dumped.
160000 rows are dumped.
170000 rows are dumped.
180000 rows are dumped.
190000 rows are dumped.
200000 rows are dumped.
210000 rows are dumped.
220000 rows are dumped.
230000 rows are dumped.
240000 rows are dumped.
250000 rows are dumped.
260000 rows are dumped.
270000 rows are dumped.
280000 rows are dumped.
290000 rows are dumped.
300000 rows are dumped.
310000 rows are dumped.
320000 rows are dumped.
330000 rows are dumped.
340000 rows are dumped.
350000 rows are dumped.
360000 rows are dumped.
370000 rows are dumped.
380000 rows are dumped.
390000 rows are dumped.
400000 rows are dumped.
410000 rows are dumped.
420000 rows are dumped.
430000 rows are dumped.
440000 rows are dumped.
450000 rows are dumped.
460000 rows are dumped.
470000 rows are dumped.
480000 rows are dumped.
490000 rows are dumped.
500000 rows are dumped.
510000 rows are dumped.
520000 rows are dumped.
530000 rows are dumped.
540000 rows are dumped.
550000 rows are dumped.
560000 rows are dumped.
570000 rows are dumped.
580000 rows are dumped.
590000 rows are dumped.
600000 rows are dumped.
610000 rows are dumped.
620000 rows are dumped.
630000 rows are dumped.
640000 rows are dumped.
650000 rows are dumped.
660000 rows are dumped.
670000 rows are dumped.
680000 rows are dumped.
690000 rows are dumped.
700000 rows are dumped.
710000 rows are dumped.
720000 rows are dumped.
730000 rows are dumped.
740000 rows are dumped.
750000 rows are dumped.
760000 rows are dumped.
770000 rows are dumped.
780000 rows are dumped.
790000 rows are dumped.
800000 rows are dumped.
810000 rows are dumped.
820000 rows are dumped.
830000 rows are dumped.
840000 rows are dumped.
850000 rows are dumped.
860000 rows are dumped.
870000 rows are dumped.
880000 rows are dumped.
890000 rows are dumped.
900000 rows are dumped.
910000 rows are dumped.
920000 rows are dumped.
930000 rows are dumped.
940000 rows are dumped.
950000 rows are dumped.
960000 rows are dumped.
970000 rows are dumped.
980000 rows are dumped.
990000 rows are dumped.
1000000 rows are dumped.
1010000 rows are dumped.
1020000 rows are dumped.
1030000 rows are dumped.
1040000 rows are dumped.
1050000 rows are dumped.
1060000 rows are dumped.
1070000 rows are dumped.
1080000 rows are dumped.
1090000 rows are dumped.
1100000 rows are dumped.
1110000 rows are dumped.
1120000 rows are dumped.
1130000 rows are dumped.
1140000 rows are dumped.
1150000 rows are dumped.
1160000 rows are dumped.
1170000 rows are dumped.
1180000 rows are dumped.
1190000 rows are dumped.
1200000 rows are dumped.
1210000 rows are dumped.
1220000 rows are dumped.
1230000 rows are dumped.
1240000 rows are dumped.
1250000 rows are dumped.
1260000 rows are dumped.
1270000 rows are dumped.
1280000 rows are dumped.
1290000 rows are dumped.
1300000 rows are dumped.
1310000 rows are dumped.
1320000 rows are dumped.
1330000 rows are dumped.
1340000 rows are dumped.
1350000 rows are dumped.
1360000 rows are dumped.
1370000 rows are dumped.
1380000 rows are dumped.
1390000 rows are dumped.
1400000 rows are dumped.
1410000 rows are dumped.
1420000 rows are dumped.
1430000 rows are dumped.
1440000 rows are dumped.
1450000 rows are dumped.
1460000 rows are dumped.
1470000 rows are dumped.
1480000 rows are dumped.
1490000 rows are dumped.
1500000 rows are dumped.
1510000 rows are dumped.
1520000 rows are dumped.
1530000 rows are dumped.
1540000 rows are dumped.
1550000 rows are dumped.
1560000 rows are dumped.
1570000 rows are dumped.
1580000 rows are dumped.
1590000 rows are dumped.
1600000 rows are dumped.
1610000 rows are dumped.
1620000 rows are dumped.
1630000 rows are dumped.
1640000 rows are dumped.
1650000 rows are dumped.
1660000 rows are dumped.
1670000 rows are dumped.
1680000 rows are dumped.
1690000 rows are dumped.
1700000 rows are dumped.
1710000 rows are dumped.
1720000 rows are dumped.
1730000 rows are dumped.
1740000 rows are dumped.
1750000 rows are dumped.
1760000 rows are dumped.
1770000 rows are dumped.
1780000 rows are dumped.
1790000 rows are dumped.
1800000 rows are dumped.
1810000 rows are dumped.
1820000 rows are dumped.
1830000 rows are dumped.
1840000 rows are dumped.
1850000 rows are dumped.
1860000 rows are dumped.
1870000 rows are dumped.
1880000 rows are dumped.
1890000 rows are dumped.
1900000 rows are dumped.
1910000 rows are dumped.
1920000 rows are dumped.
1930000 rows are dumped.
1940000 rows are dumped.
1950000 rows are dumped.
1960000 rows are dumped.
1970000 rows are dumped.
1980000 rows are dumped.
1990000 rows are dumped.
2000000 rows are dumped.
2010000 rows are dumped.
2020000 rows are dumped.
2030000 rows are dumped.
2040000 rows are dumped.
2050000 rows are dumped.
2060000 rows are dumped.
2070000 rows are dumped.
2080000 rows are dumped.
2090000 rows are dumped.
2100000 rows are dumped.
2110000 rows are dumped.
2120000 rows are dumped.
2130000 rows are dumped.
2140000 rows are dumped.
2150000 rows are dumped.
2160000 rows are dumped.
2170000 rows are dumped.
2180000 rows are dumped.
2190000 rows are dumped.
2200000 rows are dumped.
2210000 rows are dumped.
2220000 rows are dumped.
2230000 rows are dumped.
2240000 rows are dumped.
2250000 rows are dumped.
2260000 rows are dumped.
2270000 rows are dumped.
2280000 rows are dumped.
2290000 rows are dumped.
2300000 rows are dumped.
2310000 rows are dumped.
2320000 rows are dumped.
2330000 rows are dumped.
2340000 rows are dumped.
2350000 rows are dumped.
2360000 rows are dumped.
2370000 rows are dumped.
2380000 rows are dumped.
2390000 rows are dumped.
2400000 rows are dumped.
2410000 rows are dumped.
2420000 rows are dumped.
2430000 rows are dumped.
2440000 rows are dumped.
2450000 rows are dumped.
2460000 rows are dumped.
2470000 rows are dumped.
2480000 rows are dumped.
2490000 rows are dumped.
2500000 rows are dumped.
2510000 rows are dumped.
2520000 rows are dumped.
2530000 rows are dumped.
2540000 rows are dumped.
2550000 rows are dumped.
2560000 rows are dumped.
2570000 rows are dumped.
2580000 rows are dumped.
2590000 rows are dumped.
2600000 rows are dumped.
2610000 rows are dumped.
2620000 rows are dumped.
2630000 rows are dumped.
2640000 rows are dumped.
2650000 rows are dumped.
2660000 rows are dumped.
2670000 rows are dumped.
2680000 rows are dumped.
2690000 rows are dumped.
2700000 rows are dumped.
2710000 rows are dumped.
2720000 rows are dumped.
2730000 rows are dumped.
2740000 rows are dumped.
2750000 rows are dumped.
2760000 rows are dumped.
2770000 rows are dumped.
2780000 rows are dumped.
2790000 rows are dumped.
2800000 rows are dumped.
2810000 rows are dumped.
2820000 rows are dumped.
2830000 rows are dumped.
2840000 rows are dumped.
2850000 rows are dumped.
2860000 rows are dumped.
2870000 rows are dumped.
2880000 rows are dumped.
2890000 rows are dumped.
2900000 rows are dumped.
2910000 rows are dumped.
2920000 rows are dumped.
2930000 rows are dumped.
2940000 rows are dumped.
2950000 rows are dumped.
2960000 rows are dumped.
2970000 rows are dumped.
2980000 rows are dumped.
2990000 rows are dumped.
3000000 rows are dumped.
3010000 rows are dumped.
3020000 rows are dumped.
3030000 rows are dumped.
3040000 rows are dumped.
3050000 rows are dumped.
3060000 rows are dumped.
3070000 rows are dumped.
3080000 rows are dumped.
3090000 rows are dumped.
3100000 rows are dumped.
3110000 rows are dumped.
3120000 rows are dumped.
3130000 rows are dumped.
3140000 rows are dumped.
3150000 rows are dumped.
3160000 rows are dumped.
3170000 rows are dumped.
3180000 rows are dumped.
3190000 rows are dumped.
3200000 rows are dumped.
3210000 rows are dumped.
3220000 rows are dumped.
3230000 rows are dumped.
3240000 rows are dumped.
3250000 rows are dumped.
3260000 rows are dumped.
3270000 rows are dumped.
3280000 rows are dumped.
3290000 rows are dumped.
3300000 rows are dumped.
data exporting success, 3303271 rows are dumped.
exporting indexes on STEVEN.BMSQL_ORDER_LINE ...
exporting constraints on STEVEN.BMSQL_ORDER_LINE ...
exporting table STEVEN.BMSQL_ITEM ...
exporting DDL of STEVEN.BMSQL_ITEM ...
exporting data of STEVEN.BMSQL_ITEM ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
100000 rows are dumped.
data exporting success, 100000 rows are dumped.
exporting indexes on STEVEN.BMSQL_ITEM ...
exporting constraints on STEVEN.BMSQL_ITEM ...
exporting table STEVEN.BMSQL_STOCK ...
exporting DDL of STEVEN.BMSQL_STOCK ...
exporting data of STEVEN.BMSQL_STOCK ...
10000 rows are dumped.
20000 rows are dumped.
30000 rows are dumped.
40000 rows are dumped.
50000 rows are dumped.
60000 rows are dumped.
70000 rows are dumped.
80000 rows are dumped.
90000 rows are dumped.
100000 rows are dumped.
110000 rows are dumped.
120000 rows are dumped.
130000 rows are dumped.
140000 rows are dumped.
150000 rows are dumped.
160000 rows are dumped.
170000 rows are dumped.
180000 rows are dumped.
190000 rows are dumped.
200000 rows are dumped.
210000 rows are dumped.
220000 rows are dumped.
230000 rows are dumped.
240000 rows are dumped.
250000 rows are dumped.
260000 rows are dumped.
270000 rows are dumped.
280000 rows are dumped.
290000 rows are dumped.
300000 rows are dumped.
310000 rows are dumped.
320000 rows are dumped.
330000 rows are dumped.
340000 rows are dumped.
350000 rows are dumped.
360000 rows are dumped.
370000 rows are dumped.
380000 rows are dumped.
390000 rows are dumped.
400000 rows are dumped.
410000 rows are dumped.
420000 rows are dumped.
430000 rows are dumped.
440000 rows are dumped.
450000 rows are dumped.
460000 rows are dumped.
470000 rows are dumped.
480000 rows are dumped.
490000 rows are dumped.
500000 rows are dumped.
510000 rows are dumped.
520000 rows are dumped.
530000 rows are dumped.
540000 rows are dumped.
550000 rows are dumped.
560000 rows are dumped.
570000 rows are dumped.
580000 rows are dumped.
590000 rows are dumped.
600000 rows are dumped.
610000 rows are dumped.
620000 rows are dumped.
630000 rows are dumped.
640000 rows are dumped.
650000 rows are dumped.
660000 rows are dumped.
670000 rows are dumped.
680000 rows are dumped.
690000 rows are dumped.
700000 rows are dumped.
710000 rows are dumped.
720000 rows are dumped.
730000 rows are dumped.
740000 rows are dumped.
750000 rows are dumped.
760000 rows are dumped.
770000 rows are dumped.
780000 rows are dumped.
790000 rows are dumped.
800000 rows are dumped.
810000 rows are dumped.
820000 rows are dumped.
830000 rows are dumped.
840000 rows are dumped.
850000 rows are dumped.
860000 rows are dumped.
870000 rows are dumped.
880000 rows are dumped.
890000 rows are dumped.
900000 rows are dumped.
910000 rows are dumped.
920000 rows are dumped.
930000 rows are dumped.
940000 rows are dumped.
950000 rows are dumped.
960000 rows are dumped.
970000 rows are dumped.
980000 rows are dumped.
990000 rows are dumped.
1000000 rows are dumped.
data exporting success, 1000000 rows are dumped.
exporting indexes on STEVEN.BMSQL_STOCK ...
exporting constraints on STEVEN.BMSQL_STOCK ...
exporting table STEVEN.REGIONS ...
exporting DDL of STEVEN.REGIONS ...
exporting data of STEVEN.REGIONS ...
data exporting success, 4 rows are dumped.
exporting indexes on STEVEN.REGIONS ...
exporting constraints on STEVEN.REGIONS ...
exporting table STEVEN.COUNTRIES ...
exporting DDL of STEVEN.COUNTRIES ...
exporting data of STEVEN.COUNTRIES ...
data exporting success, 25 rows are dumped.
exporting indexes on STEVEN.COUNTRIES ...
exporting constraints on STEVEN.COUNTRIES ...
exporting table STEVEN.LOCATIONS ...
exporting DDL of STEVEN.LOCATIONS ...
exporting data of STEVEN.LOCATIONS ...
data exporting success, 23 rows are dumped.
exporting indexes on STEVEN.LOCATIONS ...
exporting constraints on STEVEN.LOCATIONS ...
exporting table STEVEN.DEPARTMENTS ...
exporting DDL of STEVEN.DEPARTMENTS ...
exporting data of STEVEN.DEPARTMENTS ...
data exporting success, 27 rows are dumped.
exporting indexes on STEVEN.DEPARTMENTS ...
exporting constraints on STEVEN.DEPARTMENTS ...
exporting table STEVEN.JOBS ...
exporting DDL of STEVEN.JOBS ...
exporting data of STEVEN.JOBS ...
data exporting success, 19 rows are dumped.
exporting indexes on STEVEN.JOBS ...
exporting constraints on STEVEN.JOBS ...
exporting table STEVEN.EMPLOYEES ...
exporting DDL of STEVEN.EMPLOYEES ...
exporting data of STEVEN.EMPLOYEES ...
data exporting success, 107 rows are dumped.
exporting indexes on STEVEN.EMPLOYEES ...
exporting constraints on STEVEN.EMPLOYEES ...
exporting table STEVEN.JOB_HISTORY ...
exporting DDL of STEVEN.JOB_HISTORY ...
exporting data of STEVEN.JOB_HISTORY ...
data exporting success, 10 rows are dumped.
exporting indexes on STEVEN.JOB_HISTORY ...
exporting constraints on STEVEN.JOB_HISTORY ...
Exporting procedures/functions/triggers of schema STEVEN ...
exporting TRIGGER STEVEN.BMSQL_HISTORY_BEFORE_INSERT
exporting PROCEDURE STEVEN.SECURE_DML
exporting TRIGGER STEVEN.SECURE_EMPLOYEES
exporting PROCEDURE STEVEN.ADD_JOB_HISTORY
exporting TRIGGER STEVEN.UPDATE_JOB_HISTORY
Exporting views of schema STEVEN ...
exporting view STEVEN.EMP_DETAILS_VIEW
End of export schema STEVEN ...
Logical export succeeded.
SQL> exit
[omm@pr7 ~]$ ls -l steven.dmp
-rw------- 1 omm dbgrp 1787791548 Dec 30 03:21 steven.dmp
2、新库创建用户：
[omm@pr7 ~]$ zsql / as sysdba -q
connected.
SQL> create user steven identified by modb123$;
Succeed.
SQL> grant connect,resource to steven;
Succeed.
3、imp导入用户数据：
SQL> imp users=steven file="steven.dmp";
Parsing import options ...
Verify options ...
verify schema ...
Starting import ...
Preparing to import ...
-- IMPORT TYPE = SCHEMA
-- IMPORT OBJECTS = STEVEN
-- DUMP FILE = steven.dmp
-- LOG FILE =
-- FILE TYPE = TXT
-- SHOW = N
-- FEEDBACK = 10000
-- PARALLEL = 1
-- DDL_PARALLEL = 1
-- CONTENT_MODE = ALL
-- IGNORE = N
-- CREATE_USER = N
-- TIMING = OFF
-- BATCH_COUNT = 10000
-- DISABLE_TRIGGER = Y
-- NOLOGGING = N
10000 rows are committed
20000 rows are committed
30000 rows are committed
40000 rows are committed
50000 rows are committed
60000 rows are committed
70000 rows are committed
80000 rows are committed
90000 rows are committed
100000 rows are committed
110000 rows are committed
120000 rows are committed
130000 rows are committed
140000 rows are committed
150000 rows are committed
160000 rows are committed
170000 rows are committed
180000 rows are committed
190000 rows are committed
200000 rows are committed
210000 rows are committed
220000 rows are committed
230000 rows are committed
240000 rows are committed
250000 rows are committed
260000 rows are committed
270000 rows are committed
280000 rows are committed
290000 rows are committed
300000 rows are committed
310000 rows are committed
320000 rows are committed
330000 rows are committed
340000 rows are committed
350000 rows are committed
360000 rows are committed
370000 rows are committed
380000 rows are committed
390000 rows are committed
400000 rows are committed
410000 rows are committed
420000 rows are committed
430000 rows are committed
440000 rows are committed
450000 rows are committed
460000 rows are committed
470000 rows are committed
480000 rows are committed
490000 rows are committed
500000 rows are committed
510000 rows are committed
520000 rows are committed
530000 rows are committed
540000 rows are committed
550000 rows are committed
560000 rows are committed
570000 rows are committed
580000 rows are committed
590000 rows are committed
600000 rows are committed
610000 rows are committed
620000 rows are committed
630000 rows are committed
640000 rows are committed
650000 rows are committed
660000 rows are committed
670000 rows are committed
680000 rows are committed
690000 rows are committed
700000 rows are committed
710000 rows are committed
720000 rows are committed
730000 rows are committed
740000 rows are committed
750000 rows are committed
760000 rows are committed
770000 rows are committed
780000 rows are committed
790000 rows are committed
800000 rows are committed
810000 rows are committed
820000 rows are committed
830000 rows are committed
840000 rows are committed
850000 rows are committed
860000 rows are committed
870000 rows are committed
880000 rows are committed
890000 rows are committed
900000 rows are committed
910000 rows are committed
920000 rows are committed
930000 rows are committed
940000 rows are committed
950000 rows are committed
960000 rows are committed
970000 rows are committed
980000 rows are committed
990000 rows are committed
1000000 rows are committed
1010000 rows are committed
1020000 rows are committed
1030000 rows are committed
1040000 rows are committed
1050000 rows are committed
1060000 rows are committed
1070000 rows are committed
1080000 rows are committed
1090000 rows are committed
1100000 rows are committed
1110000 rows are committed
1120000 rows are committed
1130000 rows are committed
1140000 rows are committed
1150000 rows are committed
1160000 rows are committed
1170000 rows are committed
1180000 rows are committed
1190000 rows are committed
1200000 rows are committed
1210000 rows are committed
1220000 rows are committed
1230000 rows are committed
1240000 rows are committed
1250000 rows are committed
1260000 rows are committed
1270000 rows are committed
1280000 rows are committed
1290000 rows are committed
1300000 rows are committed
1310000 rows are committed
1320000 rows are committed
1330000 rows are committed
1340000 rows are committed
1350000 rows are committed
1360000 rows are committed
1370000 rows are committed
1380000 rows are committed
1390000 rows are committed
1400000 rows are committed
1410000 rows are committed
1420000 rows are committed
1430000 rows are committed
1440000 rows are committed
1450000 rows are committed
1460000 rows are committed
1470000 rows are committed
1480000 rows are committed
1490000 rows are committed
1500000 rows are committed
1510000 rows are committed
1520000 rows are committed
1530000 rows are committed
1540000 rows are committed
1550000 rows are committed
1560000 rows are committed
1570000 rows are committed
1580000 rows are committed
1590000 rows are committed
1600000 rows are committed
1610000 rows are committed
1620000 rows are committed
1630000 rows are committed
1640000 rows are committed
1650000 rows are committed
1660000 rows are committed
1670000 rows are committed
1680000 rows are committed
1690000 rows are committed
1700000 rows are committed
1710000 rows are committed
1720000 rows are committed
1730000 rows are committed
1740000 rows are committed
1750000 rows are committed
1760000 rows are committed
1770000 rows are committed
1780000 rows are committed
1790000 rows are committed
1800000 rows are committed
1810000 rows are committed
1820000 rows are committed
1830000 rows are committed
1840000 rows are committed
1850000 rows are committed
1860000 rows are committed
1870000 rows are committed
1880000 rows are committed
1890000 rows are committed
1900000 rows are committed
1910000 rows are committed
1920000 rows are committed
1930000 rows are committed
1940000 rows are committed
1950000 rows are committed
1960000 rows are committed
1970000 rows are committed
1980000 rows are committed
1990000 rows are committed
2000000 rows are committed
2010000 rows are committed
2020000 rows are committed
2030000 rows are committed
2040000 rows are committed
2050000 rows are committed
2060000 rows are committed
2070000 rows are committed
2080000 rows are committed
2090000 rows are committed
2100000 rows are committed
2110000 rows are committed
2120000 rows are committed
2130000 rows are committed
2140000 rows are committed
2150000 rows are committed
2160000 rows are committed
2170000 rows are committed
2180000 rows are committed
2190000 rows are committed
2200000 rows are committed
2210000 rows are committed
2220000 rows are committed
2230000 rows are committed
2240000 rows are committed
2250000 rows are committed
2260000 rows are committed
2270000 rows are committed
2280000 rows are committed
2290000 rows are committed
2300000 rows are committed
2310000 rows are committed
2320000 rows are committed
2330000 rows are committed
2340000 rows are committed
2350000 rows are committed
2360000 rows are committed
2370000 rows are committed
2380000 rows are committed
2390000 rows are committed
2400000 rows are committed
2410000 rows are committed
2420000 rows are committed
2430000 rows are committed
2440000 rows are committed
2450000 rows are committed
2460000 rows are committed
2470000 rows are committed
2480000 rows are committed
2490000 rows are committed
2500000 rows are committed
2510000 rows are committed
2520000 rows are committed
2530000 rows are committed
2540000 rows are committed
2550000 rows are committed
2560000 rows are committed
2570000 rows are committed
2580000 rows are committed
2590000 rows are committed
2600000 rows are committed
2610000 rows are committed
2620000 rows are committed
2630000 rows are committed
2640000 rows are committed
2650000 rows are committed
2660000 rows are committed
2670000 rows are committed
2680000 rows are committed
2690000 rows are committed
2700000 rows are committed
2710000 rows are committed
2720000 rows are committed
2730000 rows are committed
2740000 rows are committed
2750000 rows are committed
2760000 rows are committed
2770000 rows are committed
2780000 rows are committed
2790000 rows are committed
2800000 rows are committed
2810000 rows are committed
2820000 rows are committed
2830000 rows are committed
2840000 rows are committed
2850000 rows are committed
2860000 rows are committed
2870000 rows are committed
2880000 rows are committed
2890000 rows are committed
2900000 rows are committed
2910000 rows are committed
2920000 rows are committed
2930000 rows are committed
2940000 rows are committed
2950000 rows are committed
2960000 rows are committed
2970000 rows are committed
2980000 rows are committed
2990000 rows are committed
3000000 rows are committed
3010000 rows are committed
3020000 rows are committed
3030000 rows are committed
3040000 rows are committed
3050000 rows are committed
3060000 rows are committed
3070000 rows are committed
3080000 rows are committed
3090000 rows are committed
3100000 rows are committed
3110000 rows are committed
3120000 rows are committed
3130000 rows are committed
3140000 rows are committed
3150000 rows are committed
3160000 rows are committed
3170000 rows are committed
3180000 rows are committed
3190000 rows are committed
3200000 rows are committed
3210000 rows are committed
3220000 rows are committed
3230000 rows are committed
3240000 rows are committed
3250000 rows are committed
3260000 rows are committed
3270000 rows are committed
3280000 rows are committed
3290000 rows are committed
3300000 rows are committed
3310000 rows are committed
3320000 rows are committed
3330000 rows are committed
3340000 rows are committed
3350000 rows are committed
3360000 rows are committed
3370000 rows are committed
3380000 rows are committed
3390000 rows are committed
3400000 rows are committed
3410000 rows are committed
3420000 rows are committed
3430000 rows are committed
3440000 rows are committed
3450000 rows are committed
3460000 rows are committed
3470000 rows are committed
3480000 rows are committed
3490000 rows are committed
3500000 rows are committed
3510000 rows are committed
3520000 rows are committed
3530000 rows are committed
3540000 rows are committed
3550000 rows are committed
3560000 rows are committed
3570000 rows are committed
3580000 rows are committed
3590000 rows are committed
3600000 rows are committed
3610000 rows are committed
3620000 rows are committed
3630000 rows are committed
3640000 rows are committed
3650000 rows are committed
3660000 rows are committed
3670000 rows are committed
3680000 rows are committed
3690000 rows are committed
3700000 rows are committed
3710000 rows are committed
3720000 rows are committed
3730000 rows are committed
3740000 rows are committed
3750000 rows are committed
3760000 rows are committed
3770000 rows are committed
3780000 rows are committed
3790000 rows are committed
3800000 rows are committed
3810000 rows are committed
3820000 rows are committed
3830000 rows are committed
3840000 rows are committed
3850000 rows are committed
3860000 rows are committed
3870000 rows are committed
3880000 rows are committed
3890000 rows are committed
3900000 rows are committed
3910000 rows are committed
3920000 rows are committed
3930000 rows are committed
3940000 rows are committed
3950000 rows are committed
3960000 rows are committed
3970000 rows are committed
3980000 rows are committed
3990000 rows are committed
4000000 rows are committed
4010000 rows are committed
4020000 rows are committed
4030000 rows are committed
4040000 rows are committed
4050000 rows are committed
4060000 rows are committed
4070000 rows are committed
4080000 rows are committed
4090000 rows are committed
4100000 rows are committed
4110000 rows are committed
4120000 rows are committed
4130000 rows are committed
4140000 rows are committed
4150000 rows are committed
4160000 rows are committed
4170000 rows are committed
4180000 rows are committed
4190000 rows are committed
4200000 rows are committed
4210000 rows are committed
4220000 rows are committed
4230000 rows are committed
4240000 rows are committed
4250000 rows are committed
4260000 rows are committed
4270000 rows are committed
4280000 rows are committed
4290000 rows are committed
4300000 rows are committed
4310000 rows are committed
4320000 rows are committed
4330000 rows are committed
4340000 rows are committed
4350000 rows are committed
4360000 rows are committed
4370000 rows are committed
4380000 rows are committed
4390000 rows are committed
4400000 rows are committed
4410000 rows are committed
4420000 rows are committed
4430000 rows are committed
4440000 rows are committed
4450000 rows are committed
4460000 rows are committed
4470000 rows are committed
4480000 rows are committed
4490000 rows are committed
4500000 rows are committed
4510000 rows are committed
4520000 rows are committed
4530000 rows are committed
4540000 rows are committed
4550000 rows are committed
4560000 rows are committed
4570000 rows are committed
4580000 rows are committed
4590000 rows are committed
4600000 rows are committed
4610000 rows are committed
4620000 rows are committed
4630000 rows are committed
4640000 rows are committed
4650000 rows are committed
4660000 rows are committed
4670000 rows are committed
4680000 rows are committed
4690000 rows are committed
4700000 rows are committed
4710000 rows are committed
4720000 rows are committed
4730000 rows are committed
4740000 rows are committed
4750000 rows are committed
4760000 rows are committed
4770000 rows are committed
4780000 rows are committed
4790000 rows are committed
4800000 rows are committed
4810000 rows are committed
4820000 rows are committed
4830000 rows are committed
4840000 rows are committed
4850000 rows are committed
4860000 rows are committed
4870000 rows are committed
4880000 rows are committed
4890000 rows are committed
4900000 rows are committed
4910000 rows are committed
4920000 rows are committed
4930000 rows are committed
4940000 rows are committed
4950000 rows are committed
4960000 rows are committed
4970000 rows are committed
4980000 rows are committed
4990000 rows are committed
5000000 rows are committed
5010000 rows are committed
5020000 rows are committed
5030000 rows are committed
5040000 rows are committed
5050000 rows are committed
5060000 rows are committed
5070000 rows are committed
5080000 rows are committed
5090000 rows are committed
5100000 rows are committed
5110000 rows are committed
5120000 rows are committed
5130000 rows are committed
5140000 rows are committed
5150000 rows are committed
5160000 rows are committed
5170000 rows are committed
5180000 rows are committed
5190000 rows are committed
5200000 rows are committed
5210000 rows are committed
5220000 rows are committed
5230000 rows are committed
5240000 rows are committed
5250000 rows are committed
5260000 rows are committed
5270000 rows are committed
5280000 rows are committed
5290000 rows are committed
5300000 rows are committed
5310000 rows are committed
5320000 rows are committed
5330000 rows are committed
5340000 rows are committed
5350000 rows are committed
5360000 rows are committed
5370000 rows are committed
5380000 rows are committed
5390000 rows are committed
5400000 rows are committed
5410000 rows are committed
5420000 rows are committed
5430000 rows are committed
5440000 rows are committed
5450000 rows are committed
data importing success, 5457274 rows are loaded.
Logical import succeeded.
SQL> SQL> exit;
5、查看数据：
[omm@pr7 ~]$ zsql steven/"modb123$"@127.0.0.1:1888 -q
connected.
SQL> select OBJECT_NAME,OBJECT_TYPE,CREATED from user_objects;
OBJECT_NAME OBJECT_TYPE CREATED
---------------------------------------------------------------- --------------- ------------------------------------------------
BMSQL_CONFIG TABLE 2019-12-30 04:09:35
BMSQL_CUSTOMER TABLE 2019-12-30 04:09:35
BMSQL_DISTRICT TABLE 2019-12-30 04:09:35
BMSQL_HISTORY TABLE 2019-12-30 04:10:55
BMSQL_ITEM TABLE 2019-12-30 04:22:00
BMSQL_NEW_ORDER TABLE 2019-12-30 04:11:44
BMSQL_OORDER TABLE 2019-12-30 04:11:58
BMSQL_ORDER_LINE TABLE 2019-12-30 04:12:50
BMSQL_STOCK TABLE 2019-12-30 04:22:14
BMSQL_WAREHOUSE TABLE 2019-12-30 04:09:35
COUNTRIES TABLE 2019-12-30 04:25:38
DEPARTMENTS TABLE 2019-12-30 04:25:38
EMPLOYEES TABLE 2019-12-30 04:25:38
JOBS TABLE 2019-12-30 04:25:38
JOB_HISTORY TABLE 2019-12-30 04:25:38
LOCATIONS TABLE 2019-12-30 04:25:38
REGIONS TABLE 2019-12-30 04:25:38
STEVEN_TEST TABLE 2019-12-30 04:09:35
BMSQL_CUSTOMER_IDX1 INDEX 2019-12-30 04:10:35
BMSQL_CUSTOMER_PKEY INDEX 2019-12-30 04:10:54
BMSQL_DISTRICT_PKEY INDEX 2019-12-30 04:09:35
BMSQL_ITEM_PKEY INDEX 2019-12-30 04:22:14
BMSQL_NEW_ORDER_PKEY INDEX 2019-12-30 04:11:58
BMSQL_OORDER_IDX1 INDEX 2019-12-30 04:12:48
BMSQL_OORDER_PKEY INDEX 2019-12-30 04:12:49
BMSQL_ORDER_LINE_PKEY INDEX 2019-12-30 04:21:19
BMSQL_STOCK_PKEY INDEX 2019-12-30 04:25:10
BMSQL_WAREHOUSE_PKEY INDEX 2019-12-30 04:09:35
COUNTRY_C_ID_PK INDEX 2019-12-30 04:25:38
DEPT_ID_PK INDEX 2019-12-30 04:25:38
DEPT_LOCATION_IX INDEX 2019-12-30 04:25:38
EMP_DEPARTMENT_IX INDEX 2019-12-30 04:25:38
EMP_EMAIL_UK INDEX 2019-12-30 04:25:38
EMP_EMP_ID_PK INDEX 2019-12-30 04:25:38
EMP_JOB_IX INDEX 2019-12-30 04:25:38
EMP_MANAGER_IX INDEX 2019-12-30 04:25:38
EMP_NAME_IX INDEX 2019-12-30 04:25:38
JHIST_DEPARTMENT_IX INDEX 2019-12-30 04:25:38
JHIST_EMPLOYEE_IX INDEX 2019-12-30 04:25:38
JHIST_EMP_ID_ST_DATE_PK INDEX 2019-12-30 04:25:38
JHIST_JOB_IX INDEX 2019-12-30 04:25:38
JOB_ID_PK INDEX 2019-12-30 04:25:38
LOC_CITY_IX INDEX 2019-12-30 04:25:38
LOC_COUNTRY_IX INDEX 2019-12-30 04:25:38
LOC_ID_PK INDEX 2019-12-30 04:25:38
LOC_STATE_PROVINCE_IX INDEX 2019-12-30 04:25:38
REG_ID_PK INDEX 2019-12-30 04:25:38
_PK_SYS_1_4 INDEX 2019-12-30 04:09:35
_PK_SYS_1_5 INDEX 2019-12-30 04:11:43
EMP_DETAILS_VIEW VIEW 2019-12-30 04:26:01
DV_LOG_FILES DYNAMIC VIEW 2019-12-30 03:45:39
DV_LIBRARY_CACHE DYNAMIC VIEW 2019-12-30 03:45:39
DV_SESSIONS DYNAMIC VIEW 2019-12-30 03:45:39
DV_BUFFER_POOLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_BUFFER_POOL_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_BUFFER_PAGE_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_BUFFER_INDEX_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_PARAMETERS DYNAMIC VIEW 2019-12-30 03:45:39
DV_TEMP_POOLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_OBJECT_CACHE DYNAMIC VIEW 2019-12-30 03:45:39
DV_LOCKS DYNAMIC VIEW 2019-12-30 03:45:39
DV_TABLESPACES DYNAMIC VIEW 2019-12-30 03:45:39
DV_SPINLOCKS DYNAMIC VIEW 2019-12-30 03:45:39
DV_ARCHIVED_LOGS DYNAMIC VIEW 2019-12-30 03:45:39
DV_ARCHIVE_GAPS DYNAMIC VIEW 2019-12-30 03:45:39
DV_ARCHIVE_THREADS DYNAMIC VIEW 2019-12-30 03:45:39
DV_ARCHIVE_DEST_STATUS DYNAMIC VIEW 2019-12-30 03:45:39
DV_DATABASE DYNAMIC VIEW 2019-12-30 03:45:39
DV_GMA DYNAMIC VIEW 2019-12-30 03:45:39
DV_LOCKED_OBJECTS DYNAMIC VIEW 2019-12-30 03:45:39
DV_SQLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_REPL_STATUS DYNAMIC VIEW 2019-12-30 03:45:39
DV_STANDBYS DYNAMIC VIEW 2019-12-30 03:45:39
DV_HA_SYNC_INFO DYNAMIC VIEW 2019-12-30 03:45:39
DV_VERSION DYNAMIC VIEW 2019-12-30 03:45:39
DV_TRANSACTIONS DYNAMIC VIEW 2019-12-30 03:45:39
DV_ALL_TRANS DYNAMIC VIEW 2019-12-30 03:45:39
DV_UNDO_SEGMENTS DYNAMIC VIEW 2019-12-30 03:45:39
DV_TEMP_UNDO_SEGMENT DYNAMIC VIEW 2019-12-30 03:45:39
DV_INSTANCE DYNAMIC VIEW 2019-12-30 03:45:39
DV_SESSION_WAITS DYNAMIC VIEW 2019-12-30 03:45:39
DV_SESSION_EVENTS DYNAMIC VIEW 2019-12-30 03:45:39
DV_SYS_EVENTS DYNAMIC VIEW 2019-12-30 03:45:39
DV_ME DYNAMIC VIEW 2019-12-30 03:45:39
DV_DATA_FILES DYNAMIC VIEW 2019-12-30 03:45:39
DV_SYS_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_MEM_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_SYSTEM DYNAMIC VIEW 2019-12-30 03:45:39
DV_RESOURCE_MAP DYNAMIC VIEW 2019-12-30 03:45:39
DV_USER_ASTATUS_MAP DYNAMIC VIEW 2019-12-30 03:45:39
DV_BACKUP_PROCESSES DYNAMIC VIEW 2019-12-30 03:45:39
DV_OPEN_CURSORS DYNAMIC VIEW 2019-12-30 03:45:39
NLS_SESSION_PARAMETERS DYNAMIC VIEW 2019-12-30 03:45:39
DV_PL_MANAGER DYNAMIC VIEW 2019-12-30 03:45:39
DV_DYNAMIC_VIEW_COLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_USER_PARAMETERS DYNAMIC VIEW 2019-12-30 03:45:39
DV_FREE_SPACE DYNAMIC VIEW 2019-12-30 03:45:39
DV_LONG_SQL DYNAMIC VIEW 2019-12-30 03:45:39
DV_CONTROL_FILES DYNAMIC VIEW 2019-12-30 03:45:39
DV_GMA_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_HBA DYNAMIC VIEW 2019-12-30 03:45:39
DV_SEGMENT_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_WAIT_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_LATCHS DYNAMIC VIEW 2019-12-30 03:45:39
DV_VM_FUNC_STACK DYNAMIC VIEW 2019-12-30 03:45:39
DV_PL_REFSQLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_SQL_POOL DYNAMIC VIEW 2019-12-30 03:45:39
DV_RUNNING_JOBS DYNAMIC VIEW 2019-12-30 03:45:39
DV_DC_POOLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_REACTOR_POOLS DYNAMIC VIEW 2019-12-30 03:45:39
DV_USER_ADVISORY_LOCKS DYNAMIC VIEW 2019-12-30 03:45:39
DV_SESSION_SHARED_LOCKS DYNAMIC VIEW 2019-12-30 03:45:39
DV_XACT_LOCKS DYNAMIC VIEW 2019-12-30 03:45:39
DV_XACT_SHARED_LOCKS DYNAMIC VIEW 2019-12-30 03:45:39
DV_EMERG_POOL DYNAMIC VIEW 2019-12-30 03:45:39
DV_CONNPOOL_STATS DYNAMIC VIEW 2019-12-30 03:45:39
DV_GLOBAL_TRANSACTIONS DYNAMIC VIEW 2019-12-30 03:45:39
DV_DC_RANKINGS DYNAMIC VIEW 2019-12-30 03:45:39
DV_WHITELIST DYNAMIC VIEW 2019-12-30 03:45:39
DV_RSRC_CONTROL_GROUP DYNAMIC VIEW 2019-12-30 03:45:39
DV_DYNAMIC_VIEWS DYNAMIC VIEW 2019-12-30 03:45:39
BMSQL_HISTORY_BEFORE_INSERT TRIGGER 2019-12-30 04:26:01
SECURE_DML PROCEDURE 2019-12-30 04:26:01
SECURE_EMPLOYEES TRIGGER 2019-12-30 04:26:01
ADD_JOB_HISTORY PROCEDURE 2019-12-30 04:26:01
UPDATE_JOB_HISTORY TRIGGER 2019-12-30 04:26:01
BMSQL_HIST_ID_SEQ SEQUENCE 2019-12-30 04:09:35
DEPARTMENTS_SEQ SEQUENCE 2019-12-30 04:09:35
EMPLOYEES_SEQ SEQUENCE 2019-12-30 04:09:35
LOCATIONS_SEQ SEQUENCE 2019-12-30 04:09:35
130 rows fetched.
SQL> select * from steven_test;
ID CLASS_NAME NAME
---------------------------------------- ------------------------------ --------------------------------------------------
1 222 steven
1 222 steven
1 222 steven
1 222 steven
1 222 steven
1 222 steven
2
2
3 data modb
2
2
2
3 gauss modb
3 gauss modb
3 gauss modb
3 gauss modb
3 gauss modb
3 gauss modb
3 gauss modb
3 gauss modb
20 rows fetched.
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
