Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to open database without undo tablespace?

Status
Not open for further replies.
beksalur

beksalur

Technical User
Jan 2, 2003
74
TR
Hi,
I am using Oracle 9.2.0.1 on solaris platform.
Because of my undo datafile corrupted i want to open my db without undo tablespace and then to create a new undo tablespace.

(Note:Currently I have no backup.)

Regards.
 
Sort by date Sort by votes
Change the undo parameter from spfile. Not sure though. Rollback segments can be removed from the initora file.
Hope this helps.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
645
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
325
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
319
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
313
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
372
carp
carp

Part and Inventory Search

Sponsor

Back
Top