These tips are just some quick solutions or workarounds. Use these quickies at your own risk. [#1] Oracle Data Pump Q: How to exclude the table definition while importing a table using Oracle Data Pump import utility? A: Use EXCLUDE=TABLE/TABLE option. eg., impdp login/password DUMPFILE=<DUMP_FILENAME> LOGFILE=<LOGFILE_NAME> \ DIRECTORY=<DB_DIR_NAME> TABLES=<TABLE_NAME> EXCLUDE=TABLE/TABLE [#2] Workaround to ORA-01089: immediate shutdown in progress - no operations are permitted When the database is in the middle of an...
Tuesday, 28 February 2012
Subscribe to:
Posts (Atom)