SQL*Plus Copy

The SQL*Plus COPY command can copy data between two databases via SQL*Net. Syntax: USER1 @srcdb> copy usage: COPY FROM [db] TO [db] [opt] [table] { ([cols]) } USING [sel] [db] : database string, e.g., hr/your_password@d:chicago-mktg [opt] : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE [table]: name of the destination table [cols] : a …

SQL*Plus Copy Read More »

RMAN Duplicate

Last week I had a chance to work on RMAN to duplicate the existing 3-node RAC database to another 2-node RAC database. In my case, the 2-node target already has running instances, the task here is to wipe out and copy data from production. Here is my note. I tried to put some comments to …

RMAN Duplicate Read More »

Scroll to Top