DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: unable to drop temp Tablespace

Threaded View

  1. 02-25-2003, 03:58 AM #3
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    You need to create a new temporary tablespace before dropping the default temporay tablespace.

    Create a new temporary tablespace
    Code:
    create temporary tablespace temp2
tempfile 'e:\oracle\oradata\orcl\temp2_01.dbf' size 500M;
    then make it default temporary tablespace

    Code:
    alter database default temporary tablespace temp2;
    now try to drop the temp tablespace

    HTH
    Last edited by adewri; 02-25-2003 at 04:00 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    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