-
exporting when datafile is offline
Can V take logical dump of user created object present in a offline datafile.
J Gangadhar
-
No.
Any particular reason why you can't try and find it out yourself, instad of asking in the forum?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Re: exporting when datafile is offline
Of course not. Oracle will not be able to read the offlined file.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by jmodic
No.
Any particular reason why you can't try and find it out yourself, instad of asking in the forum?
Hi Jurij
By asking like that we can become super moderator with huge no of posts No ;-)
regards
Hrishy
-
Re: exporting when datafile is offline
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...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Re: Re: exporting when datafile is offline
Originally posted by SMarkelenkov
Yes, but without data from this datafile:
So what do you export from that datafile then? Nothing.
So, your answer "Yes, but without data from this datafile" makes no sense.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|