Archives: 10/21/2011

IMPORT/EXPORT SEQUENCES

Example 1) If you didn’t delete all sequences prior to the import, you could link to the exported database and rebuild them with this script. /* Reset sequences in the one instance to anothers values */ set pages 0 /* Create statements to drop the sequences */ spool c:\temp\sequence.lst select ‘drop sequence ‘||sequence_name||’;’ from all_sequences@…

SQL*PLUS COPY COMMAND

COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, …)] USING query where database has the following syntax: username[/password]@connect_identifier. Copies data from a query to a table in a local or remote database. COPY supports the following datatypes (CHAR, DATE, LONG, NUMBER, VARCHAR2). FROM database: The database that…

Go Top