DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Dropping a tablespace

  1. 03-18-2003, 11:01 AM #1
    pcotten
    pcotten is offline Member
    Join Date
    Jan 2001
    Posts
    138

    Dropping a tablespace

    We have a tablespace with three datafiles. It has no segments. I want to drop it and reclaim the disk space. Here is the procedure I will use.

    1. Take the tablespace offline.
    2. drop tablespace
    3. Use the rm command and drop the datafiles.

    Is this good enough? Thanks.
    Reply With Quote Reply With Quote
  2. 03-18-2003, 11:07 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    That's ok
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 03-18-2003, 11:28 AM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Works for me...
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 03-18-2003, 11:43 AM #4
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: Dropping a tablespace

    Originally posted by pcotten
    We have a tablespace with three datafiles. It has no segments. I want to drop it and reclaim the disk space. Here is the procedure I will use.

    1. Take the tablespace offline.
    2. drop tablespace
    3. Use the rm command and drop the datafiles.

    Is this good enough? Thanks.
    No need for step 1.
    -nagarjuna
    Reply With Quote Reply With Quote
  5. 03-18-2003, 01:48 PM #5
    adrianomp's Avatar
    adrianomp
    adrianomp is offline Senior Member
    Join Date
    Feb 2001
    Posts
    295
    Beginning On 9i you can remove the datafiles on the DROP TABLESPACE statement with the clause INCLUDING CONTENTS AND DATAFILES.

    Just one step needed.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels
    Reply With Quote Reply With Quote
  6. 03-21-2003, 01:05 AM #6
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by adrianomp
    Beginning On 9i you can remove the datafiles on the DROP TABLESPACE statement with the clause INCLUDING CONTENTS AND DATAFILES.

    Just one step needed.
    Isnt it only for OMF?? I am not sure. Just asking. I am still an 8i DBA.
    -nagarjuna
    Reply With Quote Reply With Quote
  7. 03-21-2003, 01:38 AM #7
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by nagarjuna
    Isnt it only for OMF?? I am not sure. Just asking. I am still an 8i DBA.
    You can delete Non-OMF datafiles as well with INCLUDING CONTENTS AND DATAFILES clause.
    Last edited by SANJAY_G; 03-21-2003 at 01:43 AM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  8. 03-21-2003, 02:05 AM #8
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by SANJAY_G
    You can delete Non-OMF datafiles as well with INCLUDING CONTENTS AND DATAFILES clause.
    OIC. Thank you. :-)
    -nagarjuna
    Reply With Quote Reply With Quote
  9. 03-21-2003, 02:13 AM #9
    dasari98's Avatar
    dasari98
    dasari98 is offline Member
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47

    Re: Dropping a tablespace

    Originally posted by pcotten
    We have a tablespace with three datafiles. It has no segments. I want to drop it and reclaim the disk space. Here is the procedure I will use.

    1. Take the tablespace offline.
    2. drop tablespace
    3. Use the rm command and drop the datafiles.

    Is this good enough? Thanks.
    No need to take the tablespase offline.

    u can drop it rightaway
    Cheers
    Murali
    Reply With Quote Reply With Quote
  10. 03-21-2003, 03:58 AM #10
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by nagarjuna
    Isnt it only for OMF?? I am not sure. Just asking. I am still an 8i DBA.
    No. But if they are OMF, then DROP TABLESPACE will also remove the datafiles.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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