Home » RDBMS Server » Server Utilities » Index Oracle8 tables/database
Index Oracle8 tables/database [message #70496] Fri, 21 June 2002 15:44 Go to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
Okay, I'm a newbie to Oracle8, but I keep on getting an error when I try and delete a user from an Oracle based program. It gives me a user does not exist error. I imported the database from another server, and the application seems to be working fine. What would cause this error, and secondly, how do you reindex the database? Please help...
Re: Index Oracle8 tables/database [message #70498 is a reply to message #70496] Sun, 23 June 2002 21:21 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
You can check the user from this view v$users. I think you are only export/import the owner of schema only, so your application is working but other user is not existed. Hope this is helping.
Re: Index Oracle8 tables/database [message #70503 is a reply to message #70496] Mon, 24 June 2002 11:03 Go to previous message
Steve
Messages: 190
Registered: September 1999
Senior Member
So how do I export the users then?
Previous Topic: LogMiner
Next Topic: Error while trying to retrieve text for error ORA-03113
Goto Forum:
  


Current Time: Mon Apr 29 09:09:38 CDT 2024