exporting when datafile is offline

[ganga]

Can V take logical dump of user created object present in a offline datafile.

[jmodic]

No.

Any particular reason why you can't try and find it out yourself, instad of asking in the forum?

[julian]

Of course not. Oracle will not be able to read the offlined file.

[hrishy]

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

[SMarkelenkov]

Yes, but without data from this datafile:

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.

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.

[jmodic]

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...

[julian]

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.