千家信息网

【Oracle Database】 数据迁移(expdp/impdp)

发表于:2025-01-23 作者:千家信息网编辑
千家信息网最后更新 2025年01月23日,导出SCHEMA[oracle@king01 ~]$ sqlplus / as sysdbaSQL> col owner format a10SQL> col object_name format a
千家信息网最后更新 2025年01月23日【Oracle Database】 数据迁移(expdp/impdp)
导出SCHEMA[oracle@king01 ~]$ sqlplus / as sysdbaSQL> col owner format a10SQL> col object_name format a45SQL> col object_type format a20SQL> col status format a20SQL> select owner, object_name, object_type, status from dba_objects where owner='SOE';OWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------SOE        CUSTOMERS                                     TABLE                VALIDSOE        ADDRESSES                                     TABLE                VALIDSOE        CARD_DETAILS                                  TABLE                VALIDSOE        WAREHOUSES                                    TABLE                VALIDSOE        ORDER_ITEMS                                   TABLE                VALIDSOE        ORDERS                                        TABLE                VALIDSOE        INVENTORIES                                   TABLE                VALIDSOE        PRODUCT_INFORMATION                           TABLE                VALIDSOE        LOGON                                         TABLE                VALIDSOE        PRODUCT_DESCRIPTIONS                          TABLE                VALIDSOE        ORDERENTRY_METADATA                           TABLE                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------SOE        PRODUCTS                                      VIEW                 VALIDSOE        PRODUCT_PRICES                                VIEW                 VALIDSOE        ADDRESS_PK                                    INDEX                VALIDSOE        CUSTOMERS_PK                                  INDEX                VALIDSOE        CARD_DETAILS_PK                               INDEX                VALIDSOE        WAREHOUSES_PK                                 INDEX                VALIDSOE        ORDER_ITEMS_PK                                INDEX                VALIDSOE        ORDER_PK                                      INDEX                VALIDSOE        PRODUCT_INFORMATION_PK                        INDEX                VALIDSOE        PRD_DESC_PK                                   INDEX                VALIDSOE        INVENTORY_PK                                  INDEX                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------SOE        WHS_LOCATION_IX                               INDEX                VALIDSOE        INV_PRODUCT_IX                                INDEX                VALIDSOE        INV_WAREHOUSE_IX                              INDEX                VALIDSOE        ADDRESS_CUST_IX                               INDEX                VALIDSOE        ITEM_ORDER_IX                                 INDEX                VALIDSOE        ITEM_PRODUCT_IX                               INDEX                VALIDSOE        ORD_SALES_REP_IX                              INDEX                VALIDSOE        ORD_CUSTOMER_IX                               INDEX                VALIDSOE        ORD_ORDER_DATE_IX                             INDEX                VALIDSOE        ORD_WAREHOUSE_IX                              INDEX                VALIDSOE        CUST_ACCOUNT_MANAGER_IX                       INDEX                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------SOE        CUST_DOB_IX                                   INDEX                VALIDSOE        CUST_EMAIL_IX                                 INDEX                VALIDSOE        PROD_NAME_IX                                  INDEX                VALIDSOE        PROD_SUPPLIER_IX                              INDEX                VALIDSOE        PROD_CATEGORY_IX                              INDEX                VALIDSOE        CUST_FUNC_LOWER_NAME_IX                       INDEX                VALIDSOE        CARDDETAILS_CUST_IX                           INDEX                VALIDSOE        CUSTOMER_SEQ                                  SEQUENCE             VALIDSOE        ORDERS_SEQ                                    SEQUENCE             VALIDSOE        ADDRESS_SEQ                                   SEQUENCE             VALIDSOE        LOGON_SEQ                                     SEQUENCE             VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------SOE        CARD_DETAILS_SEQ                              SEQUENCE             VALIDSOE        ORDERENTRY                                    PACKAGE              VALIDSOE        ORDERENTRY                                    PACKAGE BODY         VALID47 rows selected.SQL> select * from dba_directories;OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH------------------------------ ------------------------------ --------------------------------------------------------------------------------SYS                            ORACLE_OCM_CONFIG_DIR          /u01/app/oracle/product/11.2.0/db_1/ccr/stateSYS                            DATA_PUMP_DIR                  /u01/app/oracle/admin/king/dpdump/SYS                            XMLDIR                         /ade/b/2125410156/oracle/rdbms/xml[oracle@king01 ~]$ expdp system/oracle schemas=soe directory=data_pump_dir dumpfile=soe_s.dmp logfile=soe.log Export: Release 11.2.0.4.0 - Production on Tue Jul 31 13:37:42 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsStarting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** schemas=soe directory=data_pump_dir dumpfile=soe_s.dmp logfile=soe.log Estimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 1.008 GBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/TABLESPACE_QUOTAProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPECProcessing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPECProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/VIEW/VIEWProcessing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODYProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICS. . exported "SOE"."ORDER_ITEMS"                         228.4 MB 4289500 rows. . exported "SOE"."INVENTORIES"                         15.15 MB  895041 rows. . exported "SOE"."ORDERS"                              129.1 MB 1429790 rows. . exported "SOE"."ADDRESSES"                           110.4 MB 1500000 rows. . exported "SOE"."CUSTOMERS"                           108.0 MB 1000000 rows. . exported "SOE"."CARD_DETAILS"                        63.88 MB 1500000 rows. . exported "SOE"."LOGON"                               51.24 MB 2382984 rows. . exported "SOE"."PRODUCT_DESCRIPTIONS"                224.5 KB    1000 rows. . exported "SOE"."PRODUCT_INFORMATION"                 187.9 KB    1000 rows. . exported "SOE"."ORDERENTRY_METADATA"                 5.539 KB       4 rows. . exported "SOE"."WAREHOUSES"                          35.07 KB    1000 rowsMaster table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:  /u01/app/oracle/admin/king/dpdump/soe_s.dmpJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Jul 31 13:38:26 2018 elapsed 0 00:00:40[oracle@king01 ~]$ scp /u01/app/oracle/admin/king/dpdump/soe_s.dmp 192.168.1.202:/u01/app/oracle/admin/king/dpdump


导入SCHEMA[oracle@king02 ~]$ impdp system/oracle directory=data_pump_dir dumpfile=soe_s.dmp remap_schema=soe:tpcc remap_tablespace=soe:tpcc transform=storage:n,segment_attributes:nImport: Release 11.2.0.4.0 - Production on Tue Jul 31 13:47:27 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsMaster table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloadedStarting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=data_pump_dir dumpfile=soe_s.dmp remap_schema=soe:tpcc remap_tablespace=soe:tpcc transform=storage:n,segment_attributes:n Processing object type SCHEMA_EXPORT/USERORA-31684: Object type USER:"TPCC" already existsProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/TABLESPACE_QUOTAProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/TABLE_DATA. . imported "TPCC"."ORDER_ITEMS"                        228.4 MB 4289500 rows. . imported "TPCC"."INVENTORIES"                        15.15 MB  895041 rows. . imported "TPCC"."ORDERS"                             129.1 MB 1429790 rows. . imported "TPCC"."ADDRESSES"                          110.4 MB 1500000 rows. . imported "TPCC"."CUSTOMERS"                          108.0 MB 1000000 rows. . imported "TPCC"."CARD_DETAILS"                       63.88 MB 1500000 rows. . imported "TPCC"."LOGON"                              51.24 MB 2382984 rows. . imported "TPCC"."PRODUCT_DESCRIPTIONS"               224.5 KB    1000 rows. . imported "TPCC"."PRODUCT_INFORMATION"                187.9 KB    1000 rows. . imported "TPCC"."ORDERENTRY_METADATA"                5.539 KB       4 rows. . imported "TPCC"."WAREHOUSES"                         35.07 KB    1000 rowsProcessing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPECProcessing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPECORA-39082: Object type ALTER_PACKAGE_SPEC:"TPCC"."ORDERENTRY" created with compilation warningsProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/VIEW/VIEWProcessing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODYORA-39082: Object type PACKAGE_BODY:"TPCC"."ORDERENTRY" created with compilation warningsProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICSJob "SYSTEM"."SYS_IMPORT_FULL_01" completed with 3 error(s) at Tue Jul 31 13:53:43 2018 elapsed 0 00:06:15


编译无效对象[oracle@king02 ~]$ sqlplus / as sysdbaSQL> col owner format a10SQL> col object_name format a45SQL> col object_type format a20SQL> col status format a20SQL> select owner, object_name, object_type, status from dba_objects where status = 'INVALID';OWNER      OBJECT_NAME                                   OBJECT_TYPE          Status---------- --------------------------------------------- -------------------- --------------------TPCC        ORDERENTRY                                    PACKAGE BODY         INVALIDSQL> alter package tpcc.orderentry compile package;Warning: Package altered with compilation errors.SQL> col text for a50SQL> select owner,name,text from dba_errors where owner='TPCC' and name='ORDERENTRY';OWNER      NAME                                               TEXT---------- -------------------------------------------------- --------------------------------------------------TPCC       ORDERENTRY                                         PLS-00201: identifier 'DBMS_LOCK' must be declaredTPCC       ORDERENTRY                                         PL/SQL: Statement ignoredTPCC       ORDERENTRY                                         PLS-00201: identifier 'DBMS_LOCK' must be declaredTPCC       ORDERENTRY                                         PL/SQL: Statement ignoredSQL> grant execute on sys.dbms_lock to tpcc;SQL> alter package tpcc.orderentry compile package;Package altered.SQL> select owner, object_name, object_type, status from dba_objects where owner='TPCC';OWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------TPCC       CUSTOMER_SEQ                                  SEQUENCE             VALIDTPCC       ORDERS_SEQ                                    SEQUENCE             VALIDTPCC       ADDRESS_SEQ                                   SEQUENCE             VALIDTPCC       LOGON_SEQ                                     SEQUENCE             VALIDTPCC       CARD_DETAILS_SEQ                              SEQUENCE             VALIDTPCC       CUSTOMERS                                     TABLE                VALIDTPCC       ADDRESSES                                     TABLE                VALIDTPCC       CARD_DETAILS                                  TABLE                VALIDTPCC       WAREHOUSES                                    TABLE                VALIDTPCC       ORDER_ITEMS                                   TABLE                VALIDTPCC       ORDERS                                        TABLE                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------TPCC       INVENTORIES                                   TABLE                VALIDTPCC       PRODUCT_INFORMATION                           TABLE                VALIDTPCC       LOGON                                         TABLE                VALIDTPCC       PRODUCT_DESCRIPTIONS                          TABLE                VALIDTPCC       ORDERENTRY_METADATA                           TABLE                VALIDTPCC       ORDERENTRY                                    PACKAGE              VALIDTPCC       CUSTOMERS_PK                                  INDEX                VALIDTPCC       ADDRESS_PK                                    INDEX                VALIDTPCC       CARD_DETAILS_PK                               INDEX                VALIDTPCC       WAREHOUSES_PK                                 INDEX                VALIDTPCC       ORDER_ITEMS_PK                                INDEX                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------TPCC       ORDER_PK                                      INDEX                VALIDTPCC       PRODUCT_INFORMATION_PK                        INDEX                VALIDTPCC       PRD_DESC_PK                                   INDEX                VALIDTPCC       INVENTORY_PK                                  INDEX                VALIDTPCC       WHS_LOCATION_IX                               INDEX                VALIDTPCC       INV_PRODUCT_IX                                INDEX                VALIDTPCC       INV_WAREHOUSE_IX                              INDEX                VALIDTPCC       ADDRESS_CUST_IX                               INDEX                VALIDTPCC       ITEM_ORDER_IX                                 INDEX                VALIDTPCC       ITEM_PRODUCT_IX                               INDEX                VALIDTPCC       ORD_SALES_REP_IX                              INDEX                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------TPCC       ORD_CUSTOMER_IX                               INDEX                VALIDTPCC       ORD_ORDER_DATE_IX                             INDEX                VALIDTPCC       ORD_WAREHOUSE_IX                              INDEX                VALIDTPCC       CUST_ACCOUNT_MANAGER_IX                       INDEX                VALIDTPCC       CUST_DOB_IX                                   INDEX                VALIDTPCC       CUST_EMAIL_IX                                 INDEX                VALIDTPCC       PROD_NAME_IX                                  INDEX                VALIDTPCC       PROD_SUPPLIER_IX                              INDEX                VALIDTPCC       PROD_CATEGORY_IX                              INDEX                VALIDTPCC       CARDDETAILS_CUST_IX                           INDEX                VALIDTPCC       CUST_FUNC_LOWER_NAME_IX                       INDEX                VALIDOWNER      OBJECT_NAME                                   OBJECT_TYPE          STATUS---------- --------------------------------------------- -------------------- --------------------TPCC       PRODUCTS                                      VIEW                 VALIDTPCC       PRODUCT_PRICES                                VIEW                 VALIDTPCC       ORDERENTRY                                    PACKAGE BODY         VALID47 rows selected.


导出表空间[oracle@king01 ~]$ sqlplus / as sysdbaSQL> execute dbms_tts.transport_set_check('soe',incl_constraints=> true,full_check=> true);PL/SQL procedure successfully completed.SQL> select * from transport_set_violations;no rows selectedSQL> alter tablespace soe read only;Tablespace altered.[oracle@king01 ~]$ expdp system/oracle dumpfile=soe.dmp directory=data_pump_dir transport_tablespaces=soe logfile=soe.log Export: Release 11.2.0.4.0 - Production on Tue Jul 31 10:28:48 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsStarting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** dumpfile=soe.dmp directory=data_pump_dir transport_tablespaces=soe logfile=soe.log Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLKProcessing object type TRANSPORTABLE_EXPORT/TABLEProcessing object type TRANSPORTABLE_EXPORT/INDEX/INDEXProcessing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_INDEX/INDEXProcessing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINTProcessing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINTProcessing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/USER_PREF_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLKMaster table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:  /u01/app/oracle/admin/king/dpdump/soe.dmp******************************************************************************Datafiles required for transportable tablespace TPCC:  /u01/app/oracle/oradata/king/soe01.dbf  /u01/app/oracle/oradata/king/soe02.dbfJob "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Tue Jul 31 10:29:09 2018 elapsed 0 00:00:20[oracle@king01 ~]$ scp /u01/app/oracle/admin/king/dpdump/soe.dmp 192.168.1.202:u01/app/oracle/admin/king/dpdump[oracle@king01 ~]$ scp /u01/app/oracle/oradata/king/soe01.dbf 192.168.1.202:/u01/app/oracle/oradata/king[oracle@king01 ~]$ scp /u01/app/oracle/oradata/king/soe02.dbf 192.168.1.202:/u01/app/oracle/oradata/king


导入表空间[oracle@king02 ~]$ sqlplus / as sysdbaSQL> create user soe identified by soe;User created.SQL> grant connect,resource to soe;Grant succeeded.[oracle@king02 ~]$ impdp system/oracle directory=data_pump_dir dumpfile=soe.dmp \transport_datafiles='/u01/app/oracle/oradata/king/soe01.dbf, /u01/app/oracle/oradata/king/soe02.dbf' \logfile=soe.logImport: Release 11.2.0.4.0 - Production on Tue Jul 31 10:06:35 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsMaster table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloadedStarting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=data_pump_dir dumpfile=soe.dmp transport_datafiles=/u01/app/oracle/oradata/king/soe01.dbf, /u01/app/oracle/oradata/king/seo02.dbf logfile=soe.log Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLKProcessing object type TRANSPORTABLE_EXPORT/TABLEProcessing object type TRANSPORTABLE_EXPORT/INDEX/INDEXProcessing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_INDEX/INDEXProcessing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINTProcessing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINTProcessing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/USER_PREF_STATISTICSProcessing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLKJob "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Tue Jul 31 10:06:39 2018 elapsed 0 00:00:04SQL> alter user soe default tablespace soe;User altered.SQL> alter tablespace soe read write;Tablespace altered.


[oracle@king01 ~]$ sqlplus soe/soeSQL> set line 200SQL> col object_name for a30SQL> select object_name,object_type,status from user_objects where object_type='TABLE';OBJECT_NAME                    OBJECT_TYPE                                               STATUS------------------------------ --------------------------------------------------------- ---------------------CUSTOMERS                      TABLE                                                     VALIDADDRESSES                      TABLE                                                     VALIDCARD_DETAILS                   TABLE                                                     VALIDWAREHOUSES                     TABLE                                                     VALIDORDER_ITEMS                    TABLE                                                     VALIDORDERS                         TABLE                                                     VALIDINVENTORIES                    TABLE                                                     VALIDPRODUCT_INFORMATION            TABLE                                                     VALIDLOGON                          TABLE                                                     VALIDPRODUCT_DESCRIPTIONS           TABLE                                                     VALIDORDERENTRY_METADATA            TABLE                                                     VALID11 rows selected.[oracle@king02 ~]$ sqlplus soe/soeSQL> set line 200SQL> col object_name for a30SQL> select object_name,object_type,status from user_objects where object_type='TABLE';OBJECT_NAME                    OBJECT_TYPE                                               STATUS------------------------------ --------------------------------------------------------- ---------------------ORDERENTRY_METADATA            TABLE                                                     VALIDPRODUCT_DESCRIPTIONS           TABLE                                                     VALIDLOGON                          TABLE                                                     VALIDPRODUCT_INFORMATION            TABLE                                                     VALIDINVENTORIES                    TABLE                                                     VALIDORDERS                         TABLE                                                     VALIDORDER_ITEMS                    TABLE                                                     VALIDWAREHOUSES                     TABLE                                                     VALIDCARD_DETAILS                   TABLE                                                     VALIDADDRESSES                      TABLE                                                     VALIDCUSTOMERS                      TABLE                                                     VALID11 rows selected.


0