• Oracle Comment On Table

Oracle Comment On Table

ORACLE-BASE - Comments for Oracle Data Pump (expdp, impdp) in Oracle Database 10g, 11g, 12c. Toggle navigation. Oracle 8i; Oracle 9i; Oracle 10g; Oracle 11g. Oracle: Export tables with the exp command and a parfile. Go to comments. This is an example of an export of selected tables with the Oracle DB command exp: Parfile.

This is an example of an export of selected tables with the Oracle DB command exp: Parfile: BUFFER=100000 TABLES=(table1,table2,table3) FILE=/path/to/exportfile.dmp LOG=/path/to/logfile.log Let’s name this file ‘export.conf’ Command: exp /@ PARFILE=export.conf This will export all data needed to recreate the tables: table1, table2 and table3 into exportfile.dmp. This file can later be used with the imp command to restore the tables To see more options of the exp command try: exp help=y This will show you a list of commands and settings.