Home » RDBMS Server » Server Administration » copy a user from a DB to another DB
copy a user from a DB to another DB [message #63894] Mon, 22 November 2004 02:23 Go to next message
mb
Messages: 51
Registered: March 2001
Member
hi

I can't import from upper vertion of oracle database(9i) to lower vertion(8) . I get this error : IMP-00069

so I want to copy a user with all of its objetcs(tables,views,...) from a database with ver9i to another database with ver 8 . what must I do?

 

Report message to a moderator

Re: copy a user from a DB to another DB [message #63895 is a reply to message #63894] Mon, 22 November 2004 02:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Use the lower version of exp and imp to do this.
POST THE COMPLETE error message with a snapshot of session.

Report message to a moderator

Re: copy a user from a DB to another DB [message #63896 is a reply to message #63894] Mon, 22 November 2004 03:46 Go to previous message
VJ
Messages: 24
Registered: June 2002
Junior Member
Export from oracle8i and then import it ...that should work .. (You might want to setup a TNS for this and then export using that...exp user@tnsnames ..... )

-VJ

Report message to a moderator

Previous Topic: trigger
Next Topic: optimal size of archive log file in Oracle 9i?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 22:50:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.