Search This Blog

Thursday, January 6, 2011

code to identify the duplicate datafiles

select max(substr(file_name,instr(file_name,'/',-1),length(file_name))) from dba_data_files where TABLESPACE_NAME='&tablespace_name';
at

1 comment:

  1. RAJADecember 13, 2013 at 9:51 AM

    Hi Venkat,
    I want to say that these article are awesome and come back to learn extra of your helpful information. I'd like to see more posts like this along with advance concepts.

    Regards
    Raja

    ReplyDelete

Subscribe to: Post Comments (Atom)

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...