| about unused tablespaces. [message #64409] |
Mon, 24 January 2005 00:56  |
priya
Messages: 108
Registered: February 2000
|
Senior Member |
|
|
can anybody help me....
to delete unused tablespaces...
can anybody suggest me a script to run........
|
|
|
|
| Re: about unused tablespaces. [message #64410 is a reply to message #64409] |
Mon, 24 January 2005 02:01  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Can you explain what is unused tablespace according to you?
Normally you can take the tablespace offline and then drop it but be carefull before deleting anything from your DB.
Daljit Singh.
|
|
|
|
| Re: about unused tablespaces. [message #64411 is a reply to message #64410] |
Mon, 24 January 2005 02:38 |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi Daljit,
unused tablespaces means when we created tablespaces for a instance,all of them is not used by all users so some of them is unused.
and i don't want to drop bacuase it's may be cause problem.
so i want to run some scripts when instance starts to delete unused tabalspaces...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
