暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Gaussdb exp bug ?

原创 李真旭 2020-02-14
1505
SQL> exp users=roger CONTENT=all file="test.dmp" PARALLEL=2; Parsing export options ... Verify options ... verify schema ... Starting export ... Preparing to export ... -- EXPORT TYPE = SCHEMA -- EXPORT OBJECTS = ROGER -- FILE TYPE = TXT -- DUMP FILE = test.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 = 2 -- CREATE_USER = N -- ROLE = N -- GRANT = N -- WITH_CR_MODE = N Exporting schema ROGER ... Exporting sequence of schema ROGER ... Exporting tables of schema ROGER ... Reading table objects of ROGER The order of exporting table is: TABLE NAME LEVEL ---------------------------------------------------------------- ---------- TEST 1 Exporting tables (scripts or data) of ROGER exporting table ROGER.TEST ... exporting DDL of ROGER.TEST ... exporting indexes on ROGER.TEST ... exporting constraints on ROGER.TEST ... Exporting procedures/functions/triggers of schema ROGER ... Exporting views of schema ROGER ... End of export schema ROGER ... Logical export succeeded.

在没有压缩的情况下,可以直接strings查看表结构,相对来讲dmp结构比较简单:

[roger@mysqldb GaussDB_100_1.0.1-TOOLS]$ strings test.dmp --** The script is dumped by *ZSQL/EXP* tool, Zenith@Huawei Gauss Dept. --** Dumped time: 2020-02-14 11:53:58.708 -- EXPORT TYPE = SCHEMA -- EXPORT OBJECTS = ROGER -- FILE TYPE = TXT -- DUMP FILE = test.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 = 2 -- CREATE_USER = N -- ROLE = N -- GRANT = N -- WITH_CR_MODE = N ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'; ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'; ALTER SESSION SET NLS_TIME_FORMAT = 'HH:MI:SS.FF AM'; ALTER SESSION SET NLS_TIME_TZ_FORMAT = 'HH:MI:SS.FF AM TZR'; ALTER SESSION SET CURRENT_SCHEMA = ROGER; DROP TABLE IF EXISTS "TEST" CASCADE CONSTRAINTS; CREATE TABLE "TEST" "A" NUMBER, "B" VARCHAR(20 BYTE) TABLESPACE "USERS" INITRANS 2 MAXTRANS 255 PCTFREE 8; ==@@ data/_3F202DA1867E08580000.D @@ data/_D6232DA186EE86A40100.D== CREATE INDEX "IDX_TEST_ID" ON "TEST"("A") TABLESPACE "USERS" INITRANS 2 PCTFREE 8; SQL> exp users=roger CONTENT=ALL file="test_batch.dmp" PARALLEL=2 TABLESPACE=y ROLE=y GRANT=y; Parsing export options ... Verify options ... verify schema ... Starting export ... Preparing to export ... -- EXPORT TYPE = SCHEMA -- EXPORT OBJECTS = ROGER -- FILE TYPE = TXT -- DUMP FILE = test_batch.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 = Y -- COMMIT_BATCH = 1000 -- INSERT_BATCH = 1 -- FEEDBACK = 10000 -- PARALLEL = 2 -- CREATE_USER = N -- ROLE = Y -- GRANT = Y -- WITH_CR_MODE = N Exporting roles ... Grant privilege to role ... Exporting schema ROGER ... Exporting grant role and privilege of schema ROGER ... Grant privilege to schema ROGER ... Grant role to schema ROGER ... Exporting sequence of schema ROGER ... Exporting tables of schema ROGER ... Reading table objects of ROGER The order of exporting table is: TABLE NAME LEVEL ---------------------------------------------------------------- ---------- TEST 1 Exporting tables (scripts or data) of ROGER exporting table ROGER.TEST ... exporting DDL of ROGER.TEST ... exporting indexes on ROGER.TEST ... exporting constraints on ROGER.TEST ... Exporting procedures/functions/triggers of schema ROGER ... Exporting views of schema ROGER ... End of export schema ROGER ... Logical export succeeded. SQL> SQL> exit [roger@mysqldb GaussDB_100_1.0.1-TOOLS]$ strings test_batch.dmp --** The script is dumped by *ZSQL/EXP* tool, Zenith@Huawei Gauss Dept. --** Dumped time: 2020-02-14 13:51:14.584 -- EXPORT TYPE = SCHEMA -- EXPORT OBJECTS = ROGER -- FILE TYPE = TXT -- DUMP FILE = test_batch.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 = Y -- COMMIT_BATCH = 1000 -- INSERT_BATCH = 1 -- FEEDBACK = 10000 -- PARALLEL = 2 -- CREATE_USER = N -- ROLE = Y -- GRANT = Y -- WITH_CR_MODE = N ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'; ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'; ALTER SESSION SET NLS_TIME_FORMAT = 'HH:MI:SS.FF AM'; ALTER SESSION SET NLS_TIME_TZ_FORMAT = 'HH:MI:SS.FF AM TZR'; GRANT CONNECT TO "ROGER"; GRANT DBA TO "ROGER"; GRANT RESOURCE TO "ROGER"; ALTER SESSION SET CURRENT_SCHEMA = ROGER; DROP TABLE IF EXISTS "TEST" CASCADE CONSTRAINTS; CREATE TABLE "TEST" "A" NUMBER, "B" VARCHAR(20 BYTE) TABLESPACE "USERS" INITRANS 2 MAXTRANS 255 PCTFREE 8; CREATE INDEX "IDX_TEST_ID" ON "TEST"("A") TABLESPACE "USERS" INITRANS 2 PCTFREE 8;

可以看到这里,dmp中没有实际数据参数。。。这是为何 ?

最后修改时间:2020-02-14 15:46:13
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论