OraFAQ Forum: Server Administration » big Trouble; USER Deleted

Home » RDBMS Server » Server Administration » big Trouble; USER Deleted

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

big Trouble; USER Deleted [message #208751]

Tue, 12 December 2006 02:05

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.

Report message to a moderator

Re: big Trouble; USER Deleted [message #208756 is a reply to message #208751]

Tue, 12 December 2006 02:39

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

You need to recreate the tablespace and import the data again. Ask you DBA for assistance.

Report message to a moderator

Re: big Trouble; USER Deleted [message #208764 is a reply to message #208756]

Tue, 12 December 2006 03:01

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;

Report message to a moderator

Re: big Trouble; USER Deleted [message #209906 is a reply to message #208764]

Mon, 18 December 2006 06:27

kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi

Member

That means your database is down. Start your database using startup command.

Report message to a moderator

Previous Topic:	database error
Next Topic:	Reclaim undused space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:41:33 CDT 2024