Can V take logical dump of user created object present in a offline datafile.
Printable View
Can V take logical dump of user created object present in a offline datafile.
No.
Any particular reason why you can't try and find it out yourself, instad of asking in the forum?
Of course not. Oracle will not be able to read the offlined file.
Hi JurijQuote:
Originally posted by jmodic
No.
Any particular reason why you can't try and find it out yourself, instad of asking in the forum?
By asking like that we can become super moderator with huge no of posts No ;-)
regards
Hrishy
Yes, but without data from this datafile:
Code:SQL> set linesize 300
SQL> select segment_name, tablespace_name,relative_fno from dba_segments where owner='SCOTT';
SEGMENT_NAME TABLESPACE_NAME RELATIVE_FNO
--------------------------------------------------------------------------------- ------------------------------ ------------
DEPT USR 4
EMP USR 4
BONUS USR 4
SALGRADE USR 4
PK_DEPT USR 4
PK_EMP USR 4
6 rows selected.
SQL> alter database datafile 4 offline;
Database altered.
Code:C:\Temp>exp scott/tiger
Export: Release 9.2.0.1.0 - Production on Sun Jan 4 22:07:58 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP >
(2)U(sers), or (3)T(ables): (2)U > 3
Export table data (yes/no): yes > yes
Compress extents (yes/no): yes > no
Export done in CL8MSWIN1251 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > emp
. . exporting table EMP
EXP-00056: ORACLE error 376 encountered
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: 'D:\ORA92\DATABASE\USR01.DBF'
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dept
. . exporting table DEPT
EXP-00056: ORACLE error 376 encountered
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: 'D:\ORA92\DATABASE\USR01.DBF'
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >
Export terminated successfully with warnings.
C:\Temp>exp scott/tiger
Export: Release 9.2.0.1.0 - Production on Sun Jan 4 22:09:31 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP >
(2)U(sers), or (3)T(ables): (2)U > 3
Export table data (yes/no): yes > no
Compress extents (yes/no): yes > no
Export done in CL8MSWIN1251 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > emp
. . exporting table EMP
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dept
. . exporting table DEPT
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
Well, object definition can hardly be considerd "object's logical dump done by export". The original question obviously implied the complete dump, togather with rows.
If he only wanted objects definition, it would be easily to simply isue some queries on the database dictionary. That's what the exp utility did in your demonstration...
So what do you export from that datafile then? Nothing.Quote:
Originally posted by SMarkelenkov
Yes, but without data from this datafile:
So, your answer "Yes, but without data from this datafile" makes no sense.