Create DB Script

[code language=”sql”] spool cr_db.sql set pages 1000 set head off set termout off set feedback off set newpage none set serveroutput on select ‘CREATE DATABASE ‘||name text from v$database; — select ‘CONTROLFILE REUSE’ from dual;  — optional select ‘LOGFILE’ from dual; declare print_var varchar2(200); cursor c1 is select member from gv$logfile where inst_id = 1 […]