OraFAQ Forum: SQL & PL/SQL » Drop schema and reclaim disk space

Home » SQL & PL/SQL » SQL & PL/SQL » Drop schema and reclaim disk space (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop schema and reclaim disk space [message #513817]

Wed, 29 June 2011 09:11

hari_bk
Messages: 110
Registered: March 2006

Senior Member

Hi

I need to drop one of the schema with 700 tables. There are other schemas in same database and tablespaces are shared across.

How can I reclaim the disk space after dropping the particular schema?

Thanks in advance
Hari

Report message to a moderator

Re: Drop schema and reclaim disk space [message #513818 is a reply to message #513817]

Wed, 29 June 2011 09:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can I reclaim the disk space after dropping the particular schema?
"reclaim" from where to where?
Space is neither created nor destroyed when create or drop objects.
space is either used or unused.
If space is unused it can be (re)used.

Report message to a moderator

Re: Drop schema and reclaim disk space [message #513821 is a reply to message #513818]

Wed, 29 June 2011 09:21

hari_bk
Messages: 110
Registered: March 2006

Senior Member

BlackSwan wrote on Wed, 29 June 2011 19:47

>How can I reclaim the disk space after dropping the particular schema?
"reclaim" from where to where?
Space is neither created nor destroyed when create or drop objects.
space is either used or unused.
If space is unused it can be (re)used.

I need to create one more schema and Import the tables. My question is the disk space is re used by the new schema ?

Thanks

Report message to a moderator

Re: Drop schema and reclaim disk space [message #513822 is a reply to message #513821]

Wed, 29 June 2011 09:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I need to create one more schema and Import the tables. My question is the disk space is re used by the new schema ?
yes, it new schema has same (default) tablespace

[Updated on: Wed, 29 June 2011 09:24]

Report message to a moderator

Re: Drop schema and reclaim disk space [message #513823 is a reply to message #513822]

Wed, 29 June 2011 09:28

hari_bk
Messages: 110
Registered: March 2006

Senior Member

BlackSwan wrote on Wed, 29 June 2011 19:54

>I need to create one more schema and Import the tables. My question is the disk space is re used by the new schema ?
yes, it new schema has same (default) tablespace

Thanks

Report message to a moderator

Previous Topic:	Create table privilege
Next Topic:	Sending an email with pdf attachments with size >32 K

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 23 12:08:52 CDT 2025