Home » RDBMS Server » Backup & Recovery » reg EXPORT and IMPORT
reg EXPORT and IMPORT [message #350981] Sun, 28 September 2008 14:04 Go to next message
dbareddy
Messages: 7
Registered: August 2008
Junior Member
Hi,
I was trying to do export of my 10g database, and then upgrade my database 10g-->11g, and then import my 10g database.
When i'm trying to export from OEM in 10g, it shows following err::

Role Error - Export and Import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and login using a different role before trying again..

And, when i tried to LOGIN with a user scott, which doesn't have a SYSDBA privilige, then it is not logging in.
can anybody please help me out,

Thanks in advance.
Re: reg EXPORT and IMPORT [message #350982 is a reply to message #350981] Sun, 28 September 2008 14:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I was trying to do export of my 10g database, and then upgrade my database 10g-->11g, and then import my 10g database.
If you are upgrading the source database to 11g, what is the purpose of exporting and importing 10g schema again?
>>then it is not logging in.
May be the account is locked. May account does not exist.
Too many possibilities.
Post the exact error you get.
Re: reg EXPORT and IMPORT [message #350984 is a reply to message #350981] Sun, 28 September 2008 14:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

YOu can't export/import database with "sys as sysdba" user in 10g or later.

[Updated on: Sun, 28 September 2008 14:46]

Report message to a moderator

Previous Topic: RMAN Backup
Next Topic: RMAN: ORA-01587: error during control file backup file copy.
Goto Forum:
  


Current Time: Mon Dec 05 19:18:01 CST 2016

Total time taken to generate the page: 0.16912 seconds