AskDBA.org Forum Forum for Oracle DBA's

About This Topic

• Posted 2 years ago
• By Amit Bansal
• Latest reply from Amit Bansal
• This topic is not a support question
• RSS feed for this topic

Tags

• cloning
• database
• sql

1. 

   Amit Bansal
   

   Oracle DBA
   Joined: Jun '08
   Posts: 73

   offline

   Reputation:96

    

   
   Posted 2 years ago
   #

   While performing a manual db cloning, you are required to create database directories. Using instr and substr function can help you with this and can list the create directory script

   select distinct('mkdir -p '||substr(file_name,1,instr(file_name,'/',-1,1)-1)) from dba_data_files
   union
   select distinct('mkdir -p '||substr(name,1,instr(name,'/',-1,1)-1)) from v$controlfile
   union
   select distinct('mkdir -p '||substr(member,1,instr(member,'/',-1,1)-1)) from v$logfile
   union
   select distinct('mkdir -p '||substr(file_name,1,instr(file_name,'/',-1,1)-1)) from dba_temp_files;
   

   Hope this helps

   Cheers
   Amit
   http://askdba.org/weblog/
2. 

   Anonymous
   

   
   
   Posts: 3

   offline

   Reputation:1

    

   
   Posted 1 year ago
   #

   Thanks man for the help i was trying to get a shortcut to create the database and you have done a lot for me by providing this function