Home » RDBMS Server » Server Administration » big Trouble; USER Deleted
big Trouble; USER Deleted [message #208751] Tue, 12 December 2006 02:05 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I was altering TABLESPACE through oracle enterprises manager > storage manager unfortunately I deleted my TABLESPACE,
now I cannot connect with my user what should I do??? I have a DMP file Please help.



Re: big Trouble; USER Deleted [message #208756 is a reply to message #208751] Tue, 12 December 2006 02:39 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You need to recreate the tablespace and import the data again. Ask you DBA for assistance.
Re: big Trouble; USER Deleted [message #208764 is a reply to message #208756] Tue, 12 December 2006 03:01 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I dont have DBA

I am using Oracle 8
when I try to connect shows the error
ORA-01034 oracle not avaible

And I am using this line for DMP file

str :='Exp80 userID='||user_name||'/'||pass||'@'||Cstring||' rows=y file='||:Path;
Re: big Trouble; USER Deleted [message #209906 is a reply to message #208764] Mon, 18 December 2006 06:27 Go to previous message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
That means your database is down. Start your database using startup command.
Previous Topic: database error
Next Topic: Reclaim undused space
Goto Forum:
  


Current Time: Thu Dec 08 18:02:24 CST 2016

Total time taken to generate the page: 0.13716 seconds