Home » RDBMS Server » Enterprise Manager » Export/Import using OEM in 10g
Export/Import using OEM in 10g [message #283010] Sun, 25 November 2007 23:20 Go to next message
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 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Maintenance_>Data Movement-> Move Row Data
Then option you pick and continue.
Re: Export/Import using OEM in 10g [message #283014 is a reply to message #283010] Sun, 25 November 2007 23:28 Go to previous messageGo to next message
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
Re: Export/Import using OEM in 10g [message #283017 is a reply to message #283010] Sun, 25 November 2007 23:31 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Taj , is it in 10g?
Re: Export/Import using OEM in 10g [message #283022 is a reply to message #283017] Sun, 25 November 2007 23:35 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?

Re: Export/Import using OEM in 10g [message #283040 is a reply to message #283038] Mon, 26 November 2007 00:22 Go to previous messageGo to next message
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.
Re: Export/Import using OEM in 10g [message #283044 is a reply to message #283010] Mon, 26 November 2007 00:26 Go to previous messageGo to next message
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.
Re: Export/Import using OEM in 10g [message #283055 is a reply to message #283044] Mon, 26 November 2007 00:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And arju,
what about 11g...Smile
did you try with 11g ?
Re: Export/Import using OEM in 10g [message #283072 is a reply to message #283010] Mon, 26 November 2007 01:17 Go to previous messageGo to next message
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

Re: Export/Import using OEM in 10g [message #283074 is a reply to message #283010] Mon, 26 November 2007 01:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

NO Taj , I have not 11g.
Re: Export/Import using OEM in 10g [message #283076 is a reply to message #283072] Mon, 26 November 2007 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Export/Import using OEM in 10g [message #283078 is a reply to message #283010] Mon, 26 November 2007 01:24 Go to previous messageGo to next message
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.
Re: Export/Import using OEM in 10g [message #283081 is a reply to message #283072] Mon, 26 November 2007 01:26 Go to previous messageGo to next message
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
Re: Export/Import using OEM in 10g [message #283082 is a reply to message #283078] Mon, 26 November 2007 01:28 Go to previous messageGo to next message
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.
Re: Export/Import using OEM in 10g [message #283083 is a reply to message #283010] Mon, 26 November 2007 01:29 Go to previous messageGo to next message
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:"
Re: Export/Import using OEM in 10g [message #283099 is a reply to message #283010] Mon, 26 November 2007 01:58 Go to previous messageGo to next message
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.
Re: Export/Import using OEM in 10g [message #283100 is a reply to message #283083] Mon, 26 November 2007 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Export/Import using OEM in 10g [message #283102 is a reply to message #283010] Mon, 26 November 2007 02:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thank Michel for the clarification.

Thank you Taj also.
Re: Export/Import using OEM in 10g [message #283292 is a reply to message #283074] Mon, 26 November 2007 10:48 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Arju wrote on Mon, 26 November 2007 00:20

NO Taj , I have not 11g.



Here's the 11g look bit different from 10g.
/forum/fa/3455/0/
  • Attachment: oem7.JPG
    (Size: 56.85KB, Downloaded 3416 times)
Re: Export/Import using OEM in 10g [message #283355 is a reply to message #283292] Mon, 26 November 2007 22:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Smile that is great...
so you start to explore 11g...Smile
Re: Export/Import using OEM in 10g [message #283547 is a reply to message #283010] Tue, 27 November 2007 07:56 Go to previous messageGo to next message
irfanr
Messages: 11
Registered: December 2006
Location: india
Junior Member
Dear Sir,

Thanks for Great Support.

a very valuable information on the topic.

Regards
Irfan


Re: Export/Import using OEM in 10g [message #283632 is a reply to message #283355] Tue, 27 November 2007 15:05 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yup.Just trying to write small topics for ORAFAQ/wiki.
Previous Topic: EM control
Next Topic: grid control shows cluster nodes seperately
Goto Forum:
  


Current Time: Thu Mar 28 05:40:37 CDT 2024