open dbf
Hi all,
I'm trying to open dbf file, please look at my steps and tell me what is wrong (if possible).
1. I've created package
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:711825134415
2. Found full path of datafile:
select name from V$datafile
R:\ORCLAA7\ORCLAA7\SYSTEM01.DBF
R:\ORCLAA7\ORCLAA7\SYSAUX01.DBF
R:\ORCLAA7\ORCLAA7\UNDOTBS01.DBF
R:\ORCLAA7\ORCLAA7\USERS01.DBF
R:\ORCLAA7\ORCLAA7\RSACOREDATA.DBF
R:\ORCLAA7\ORCLAA7\RSACOREINDEX.DBF
R:\ORCLAA7\ORCLAA7\RSABODATA.DBF
R:\ORCLAA7\ORCLAA7\RSABOINDEX.DBF
R:\ORCLAA7\ORCLAA7\RSACMDATA.DBF
R:\ORCLAA7\ORCLAA7\RSACMINDEX.DBF
I'm trying to open dbf file, please look at my steps and tell me what is wrong (if possible).
1. I've created package
dbase_pkgusing Tom's guide
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:711825134415
2. Found full path of datafile:
select name from V$datafile
R:\ORCLAA7\ORCLAA7\SYSTEM01.DBF
R:\ORCLAA7\ORCLAA7\SYSAUX01.DBF
R:\ORCLAA7\ORCLAA7\UNDOTBS01.DBF
R:\ORCLAA7\ORCLAA7\USERS01.DBF
R:\ORCLAA7\ORCLAA7\RSACOREDATA.DBF
R:\ORCLAA7\ORCLAA7\RSACOREINDEX.DBF
R:\ORCLAA7\ORCLAA7\RSABODATA.DBF
R:\ORCLAA7\ORCLAA7\RSABOINDEX.DBF
R:\ORCLAA7\ORCLAA7\RSACMDATA.DBF
R:\ORCLAA7\ORCLAA7\RSACMINDEX.DBF
0