OraFAQ Forum: Enterprise Manager » How to Export/Import in Windows-Oracle10g-EnterprisesManager

Home » RDBMS Server » Enterprise Manager » How to Export/Import in Windows-Oracle10g-EnterprisesManager

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

How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #229825]

Tue, 10 April 2007 02:30

sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI

Member

Hi
How to Export/Import full database in Windows operating system / Oracle 10g through Enterprises manager.(I know how to do this using command prompt,but I wanted to do this by using Enterprises manager of 10g)

1)Which oracle user has privilege to logon in Enterprises manager for export/import purpose.(I loged on as sys as sysdba,but it show error)

2)After loging on to the Enterprises manager's Maintaince menu (as sysdba)it asks Host credential here whether i should give OS administrator name & password or Oracle user name & password.

by
balamuralikrishnan.s

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #229831 is a reply to message #229825]

Tue, 10 April 2007 02:41

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

Senior Member

Hi,
.(I loged on as sys as sysdba,but it show error)
Yes because you cann't export/import with sys user. you have to use other user.

You can do with any user but they have sufficient privs to export your database according export type.

one more thing you have to grant "LOG ON BATCH JOB" OS privs to user.

control panel ---> administrative tools ---> user assignment rights ---> LOG ON BATCH JOB.

Regards
Taj

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #230085 is a reply to message #229831]

Tue, 10 April 2007 17:51

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Hi Taj/Bala

As far as my understanding we have to configure repository (O
MS) if you want to take export or import through OEM and with SYS user. SYS is super user and we can able to export/import through SYS user.

Let me know if you have any concerns.

Regards,
Harshad

[Updated on: Tue, 10 April 2007 17:52]

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #230117 is a reply to message #230085]

Tue, 10 April 2007 23:20

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

Senior Member

Hi,
SYS is super user and we can able to export/import through SYS user.

AFAIK You cann't execute export command with SYS user.

Regards
Taj

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #230119 is a reply to message #230117]

Tue, 10 April 2007 23:25

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

You can invoke export with sysdba privilege.

Regards,
HArshad

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233081 is a reply to message #230119]

Tue, 24 April 2007 10:02

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

hi harsh, i read and tried too...
We cannot do datapump export or import in we are logged in as sysdba..
According to you, it's possible, then please let me know that..

Regards

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233086 is a reply to message #233081]

Tue, 24 April 2007 10:13

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

Senior Member

Hi,
We cannot do datapump export or import in we are logged in as sysdba..
According to you, it's possible, then please let me know that..

It is not possible.

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233092 is a reply to message #233086]

Tue, 24 April 2007 11:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

expdp or exp
Just use the PARFILE

oracle@xxxx:~> expdp parfile=par.par

Export: Release 10.2.0.2.0 - 64bit Production on Tuesday, 24 April, 2007 12:10:20

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  parfile=par.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "DBADMIN"."ADULTAGE"                        5.570 KB       2 rows
. . exported "DBADMIN"."CF":"PART_1"                     5.546 KB       2 rows
. . exported "DBADMIN"."CF":"PART_3"                     5.531 KB       1 rows
. . exported "DBADMIN"."DEPT"                            5.609 KB       4 rows
. . exported "DBADMIN"."EMP"                             7.726 KB      14 rows
. . exported "DBADMIN"."T1"                              4.929 KB       1 rows
. . exported "DBADMIN"."CF":"PART_2"                         0 KB       0 rows
. . exported "DBADMIN"."DATE_TABLE"                          0 KB       0 rows
. . exported "DBADMIN"."PLAN_TABLE"                          0 KB       0 rows
. . exported "DBADMIN"."TEST"                                0 KB       0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  /u01/home/rdbms/log/expdat.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 
12:11:12

oracle@xxxx:~> cat par.par
userid="sys/sys as sysdba" schemas=dbadmin

or
Properly escape your quotes according to your OS

oracle@xxxx:~> expdp 'userid="/ as sysdba"' schemas=dbadmin

Export: Release 10.2.0.2.0 - 64bit Production on Tuesday, 24 April, 2007 12:13:30

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  userid="/******** AS SYSDBA" schemas=dbadmin
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "DBADMIN"."ADULTAGE"                        5.570 KB       2 rows
. . exported "DBADMIN"."CF":"PART_1"                     5.546 KB       2 rows
. . exported "DBADMIN"."CF":"PART_3"                     5.531 KB       1 rows
. . exported "DBADMIN"."DEPT"                            5.609 KB       4 rows
. . exported "DBADMIN"."EMP"                             7.726 KB      14 rows
. . exported "DBADMIN"."T1"                              4.929 KB       1 rows
. . exported "DBADMIN"."CF":"PART_2"                         0 KB       0 rows
. . exported "DBADMIN"."DATE_TABLE"                          0 KB       0 rows
. . exported "DBADMIN"."PLAN_TABLE"                          0 KB       0 rows
. . exported "DBADMIN"."TEST"                                0 KB       0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  /u01/home/rdbms/log/expdat.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:13:50

[Updated on: Tue, 24 April 2007 11:11]

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233098 is a reply to message #233092]

Tue, 24 April 2007 12:00

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

Senior Member

Hi Mahesh,

Yes your example is correct.
but we cann't export with SYSDBA role in ORACLE ENTERPRISE MANAGER not command line.

Regards
Taj

[Updated on: Tue, 24 April 2007 12:01]

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233101 is a reply to message #233098]

Tue, 24 April 2007 12:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

The question asked was

Quote:

We cannot do datapump export or import in we are logged in as sysdba..

And i cannot contend your response as i have no OEM in vicinity and i have not used one in years.

UPDATE:
Not supported in 10g OEM. Was able to reproduce this

Quote:

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.

[Updated on: Tue, 24 April 2007 21:29]

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233132 is a reply to message #233101]

Tue, 24 April 2007 20:40

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

hi friends,

I have faced that while logged in as sysdba user, we can't do datapump activities...
I tried a lot to find the reason, but couldn't..
If anyone has idea, please explain, what's the technical reason behind this.. why oracle has not allowed us to do that as sysdba...

Regards..

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400320 is a reply to message #229825]

Mon, 27 April 2009 09:28

sasiram
Messages: 2
Registered: April 2009

Junior Member

Bala,

Use sysman account instead of sys. The password will be the same as sys if you set all main accounts with same password during database creation.

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400358 is a reply to message #400320]

Mon, 27 April 2009 16:06

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

Good !!!

Before reply any thread check last update. <<Wed, 25 April 2007 07:10>>

Babu

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400359 is a reply to message #229825]

Mon, 27 April 2009 16:27

sasiram
Messages: 2
Registered: April 2009

Junior Member

Hello gentlebabu,

I do not see any posts on Apr 25th on this thread. What could be the reason ?

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400360 is a reply to message #229825]

Mon, 27 April 2009 17:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Look at the post in this thread above as URL
http://www.orafaq.com/forum/m/400359/136107/#msg_233132
This post it contains a timestamp of "Tue, 24 April 2007 18:40" for me.

>I do not see any posts on Apr 25th on this thread. What could be the reason ?
The reason is because the timestamps on posts are timezone adjusted.

Report message to a moderator

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #402373 is a reply to message #229825]

Sat, 09 May 2009 10:46

sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI

Member

yes!
for my 2 yrs old question, NOW Laughing

Laughing

I am getting more useful answers Thanks Mr.Sisram & Gentelbabu

Actually I was working in windows+oracle environment so that
"LOG ON BATCH JOB" solved my problem.

New answers may be helpful for unix environment.
by
Balamurali Krishnan.S

Report message to a moderator

Previous Topic:	db shutting down while navigating enterprise manager links
Next Topic:	Enterprise manager configuration failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 17:16:49 CST 2024