http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 10:52:16 +0000 http://www.forum.askdba.org/topic/using-instr-function-to-get-filesytem-structure-for-manual-db-clone#post-157 Sat, 12 Jun 2010 11:01:52 +0000 Anonymous 157@http://www.forum.askdba.org/ <p>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 </p> http://www.forum.askdba.org/topic/using-instr-function-to-get-filesytem-structure-for-manual-db-clone#post-78 Wed, 19 Aug 2009 16:59:43 +0000 Amit Bansal 78@http://www.forum.askdba.org/ <p>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</p> <pre> 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; </pre> <p>Hope this helps </p>