exporting when datafile is offline
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: exporting when datafile is offline

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    exporting when datafile is offline

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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    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

  5. #5
    Join Date
    Jan 2004
    Location
    Russia
    Posts
    4

    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.

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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
  •  


Click Here to Expand Forum to Full Width