Hi,
I have been trying to duplicate a Application Instance on the same server.
I could not find any documentation. I found a couple of links, http://www.dbatoolbox.com/WP2001/cloning/apps1_clone11_instan.pdf
and
http://www.dbatoolbox.com/WP2001/cloning/apps1_clone_r11.pdf
BUT, the link...
REM set pause off
REM set pages 0
column file_id format 999
column tablespace_name format a12
column file_name format a30
column bytes format 999
SELECT f.file_id,
d.tablespace_name,
d.file_name,
round((d.bytes/1048576),2) MB,
round(((d.bytes - sum(nvl(f.bytes,0))) /...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.