[Amit Bansal]

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

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

Hope this helps

[Author]

Posts