OraFAQ Forum: Enterprise Manager » Export/Import using OEM in 10g

Home » RDBMS Server » Enterprise Manager » Export/Import using OEM in 10g

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

Export/Import using OEM in 10g [message #283010]

Sun, 25 November 2007 23:20

irfanr
Messages: 11
Registered: December 2006
Location: india

Junior Member

Hi

can u share the steps to export /import using OEM connected as sysdba?

Thanks

[Updated on: Sun, 25 November 2007 23:20]

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283012 is a reply to message #283010]

Sun, 25 November 2007 23:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Maintenance_>Data Movement-> Move Row Data
Then option you pick and continue.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283014 is a reply to message #283010]

Sun, 25 November 2007 23:28

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

login to OEM. 
then go ===> Maintenance ===> Utilities 
                              1. Export to files
                              2. Import from files

Hope this help

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283017 is a reply to message #283010]

Sun, 25 November 2007 23:31

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Taj , is it in 10g?

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283022 is a reply to message #283017]

Sun, 25 November 2007 23:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Yes arju,
http://www.exforsys.com/images/oracle10g/t9_files/image008.jpg

[Updated on: Mon, 26 November 2007 00:22]

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283038 is a reply to message #283010]

Mon, 26 November 2007 00:14

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I wonder mine is also in 10g but different lokk. Did you upgrade version or direct instal 10g?

Attachment: OEM Export.JPG
(Size: 141.98KB, Downloaded 1548 times)

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283040 is a reply to message #283038]

Mon, 26 November 2007 00:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Prod
PL/SQL Release 10.1.0.5.0 - Production
CORE    10.1.0.5.0      Production
TNS for 32-bit Windows: Version 10.1.0.5.0 - Production
NLSRTL Version 10.1.0.5.0 - Production

Database is 10gr1.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283044 is a reply to message #283010]

Mon, 26 November 2007 00:26

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Yes, this is the difference.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

Thank you Taj.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283055 is a reply to message #283044]

Mon, 26 November 2007 00:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

And arju,
what about 11g... Smile

did you try with 11g ?

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283072 is a reply to message #283010]

Mon, 26 November 2007 01:17

irfanr
Messages: 11
Registered: December 2006
Location: india

Junior Member

Sir,

i am using

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

as u said i followed u r steps

login to OEM.
then go ===> Maintenance ===> Utilities
1. Export to files
2. Import from files

Still i am receiving the following error.

Validation Error
Examine and correct the following errors, then retry the operation:
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.

kindly suggest me other step or is this a bug!

Regards
irfan

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283074 is a reply to message #283010]

Mon, 26 November 2007 01:20

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

NO Taj , I have not 11g.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283076 is a reply to message #283072]

Mon, 26 November 2007 01:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As it is said: 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.
So do it.

Regards
Michel

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283078 is a reply to message #283010]

Mon, 26 November 2007 01:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

@Irfan . So as suggested log on as a user who don't have sysdba privilege. By the way , it is an oracle bug export can be done by the user who has sysdba privilege.

It is internal bug no 6282278.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283081 is a reply to message #283072]

Mon, 26 November 2007 01:26

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Actually i didn't read you post with carefully.
we can't export database in 10g through SYSDBA role.
this is not bug, this is restriction for using "sys" magic user.

http://dbataj.blogspot.com/2007/04/export-database-with-sysdba-role.html

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283082 is a reply to message #283078]

Mon, 26 November 2007 01:28

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

it is an oracle bug export can be done by the user who has sysdba privilege.
Yes arju, but not through OEM, we can use sysdba user as sql command line in 10g.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283083 is a reply to message #283010]

Mon, 26 November 2007 01:29

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

https://metalink.oracle.com/metalink/plsql/f?p=130:14:3958422095487349763::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,454792.1,1,1,1,helvetica

Search for keyword "Solution to issue 2:"

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283099 is a reply to message #283010]

Mon, 26 November 2007 01:58

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

we can't export database in 10g through SYSDBA role.

>I think, You want to mean in OEM, not in command prompt.

this is not bug, this is restriction for using "sys" magic user.

>I think it is a bug.

Report message to a moderator

Re: Export/Import using OEM in 10g [message #283100 is a reply to message #283083]

Mon, 26 November 2007 01:59

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not a bug, it is a restriction of use. OEM was explicitly coded with it.
The fact that a bug is logged does not mean this is a bug.
Many bug reports end with "Not a bug" status.

This said, if you want to use SYS to export just don't use OEM.

Regards
Michel

Report message to a moderator