No Picture

RMAN: Basic RMAN Commands

November 23, 2017 Vashishth 0

Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performant, manageable backup and recovery, for all Oracle data formats. RMAN  provides a common interface, […]

No Picture

Move SQL PROFILE to other database

November 23, 2017 Vashishth 0

A)  CREATE STAGING TABLE First Create the staging table which will hold sql profiles to be moved over. SQL> exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name=>’SQL_STG_TAB’,schema_name=>’SYS’); (This will create […]