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 »

Change column width of show parameter in SQL Plus

You can change the width of the NAME, TYPE and VALUE of “show parameter” in SQL/Plus. SQL> show parameter sga NAME TYPE —————————— —————————— VALUE—————————— lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer0 SQL> column NAME_COL_PLUS_SHOW_PARAM format A20 SQL> column TYPE format A20 SQL> column VALUE_COL_PLUS_SHOW_PARAM format A20 SQL> show …

Change column width of show parameter in SQL Plus Read More »

Scroll to Top