driopping datafiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: driopping datafiles

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Hi ,

    I've dropped a datafile using
    alter database datafile 'XXXXXXX' offline drop;

    but now the datafile is offline but is still in the catalog. I cant bring it online cause it needs recovery and I'm in NOARCHIVELOG mode. How to I drop it out of the catalog?

    Running 8.1.7.3 on AIX 4.3.3

  2. #2
    Join Date
    Mar 2002
    Posts
    12
    Hello Fraze,

    is the datafile you dropped the only member of its tablespace?

    I'm pretty sure you'll have to drop the tablespace now.

    Regards,
    Noel.

  3. #3
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Angry Dropping datafile

    Hi,

    You cann't get rid of it with out dropping the tablespace.

    The procedure would be.

    For a tablespace with tables in it:
    - do an export containg all the tables
    - drop and recreate the tablespace
    - do an import

    For a tablespace with indexes in it:
    - get the create statements for all the indexes in the tablespace
    - drop and recreate the tablespace
    - create the indexes

    HTH

    Tycho

  4. #4
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Thanx,

    Forgot that once you create a datafile in cant be dropped by itself. Have recovered it and brought it online - guess I'll just live with it for now!

  5. #5
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    Hi,

    Can you send in the output of the following query?

    select *
    from v$RECOVER_FILE;

    Tycho

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