Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Sep 4 11:18:31 2018 elapsed 0 00:00:10 Include multiple tables from schema dump_bkp]$ expdp system directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir include=table:"in\('T1'\,'T2'\)"Įxport: Release 11.2.0.4.0 - Production on Tue Sep 4 11:35:24 2018 Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/USER Total estimation using BLOCKS method: 128 KB Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir exclude=TABLE:IN('T1') Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Sep 4 11:16:44 2018 elapsed 0 00:00:09 Exclude Single table from schema dump_bkp]$ expdp system directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir exclude=TABLE:"IN('T1')"Įxport: Release 11.2.0.4.0 - Production on Tue Sep 4 11:18:17 2018
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ Processing object type SCHEMA_EXPORT/TABLE/TABLE Total estimation using BLOCKS method: 64 KB Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir include=TABLE:IN('T1')Įstimate in progress using BLOCKS method. With the Partitioning, OLAP, Data Mining and Real Application Testing optionsįLASHBACK automatically enabled to preserve database integrity. All rights reserved.Ĭonnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
#HOW TO DELETE ORACLE 11G ENTERPRISE EDITION HOW TO#
How to exclude Single or Multiple tables from schema by using from EXPDP Include Single table from schema dump_bkp]$ expdp system directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir include=TABLE:"IN('T1')"Įxport: Release 11.2.0.4.0 - Production on Tue Sep 4 11:16:31 2018Ĭopyright (c) 1982, 2011, Oracle and/or its affiliates. Check also that the services have been removed, if they are still listed then you can open a DOS prompt with administrator privileges and then use sc delete. You can now check that the database has been dropped by checking that the database files have been removed. Total System Global Area 2137886720 bytesĥ – Drop the database SQL> drop database ĭisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64 bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsģ – Shutdown the database SQL> shutdown immediateĤ – Startup the database in exclusive mode SQL> startup mount exclusive restrict Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production If, when you come to remove an Oracle database, you find that DBCA is not available perhaps due to some installation issue or missing files then do not fret as it is still possible to remove the database by following these steps…ġ – Set the Oracle SID D:\Oracle\product\11.2.0\dbhome_1\BIN>set ORACLE_SID=TESTDBĢ – Connect to the database and verify the name D:\Oracle\product\11.2.0\dbhome_1\BIN>sqlplus / as sysdba
0 kommentar(er)
