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.




Reply With Quote