asked on

Set up or drop Default tablespace

Hi dear all experts:

How to set up default tablespace? In any ini or ora file?

The default tablespace I have here seems corrupted. Can I re-create another default tablespace and drop the original one? Do I have to do anything in Storage Manager or anywhere to set it up as new default tablespace?

Thanks a lot!!

ASKER CERTIFIED SOLUTION

dbrower

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

UsamaMunir

If ur talking about System tablespace then i am afraid it sounds trouble, u will probablyhave to retore from a previous backup.

FarazMSyed

hi mingichu!!!

Can u explain y did u say in your question that your tablespace is corrupt ... cause if u r having any error then please mention it in your question ...

Other then that if u want to create another default tablespace ... then u can by connecting through system user... and in SQLPLUS
CREATE TABLESPACE <new_tablespace_name> LOGGING DATAFILE '<path for Database file>' SIZE 200M EXTENT MANAGEMENT LOCAL;

and modify your user ....
ALTER USER <your_username>DEFAULT TABLESPACE <new_tablespace_name>;

if u have further problem please do ask ...

regards
Faraz

Netminder

There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of

DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.

mingichu,

Some of these questions have been open for some time, and records indicate you logged in as recently as this week. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.

https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20260860
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20176286
https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=20156941
https://www.experts-exchange.com/jsp/qShow.jsp?ta=lotusnotes&qid=20138024

Thanks,

Netminder
Community Support Moderator
Experts Exchange

Moondancer

Zero response from anyone, finalized.
Moondancer - EE Moderator