Home » RDBMS Server » Enterprise Manager » How to Export/Import in Windows-Oracle10g-EnterprisesManager
How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #229825] Tue, 10 April 2007 02:30 Go to next message
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
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #229831 is a reply to message #229825] Tue, 10 April 2007 02:41 Go to previous messageGo to next message
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
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #230085 is a reply to message #229831] Tue, 10 April 2007 17:51 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #230119 is a reply to message #230117] Tue, 10 April 2007 23:25 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
You can invoke export with sysdba privilege.

Regards,
HArshad
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233081 is a reply to message #230119] Tue, 24 April 2007 10:02 Go to previous messageGo to next message
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
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233086 is a reply to message #233081] Tue, 24 April 2007 10:13 Go to previous messageGo to next message
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.
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #233092 is a reply to message #233086] Tue, 24 April 2007 11:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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..
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400320 is a reply to message #229825] Mon, 27 April 2009 09:28 Go to previous messageGo to next message
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.

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400358 is a reply to message #400320] Mon, 27 April 2009 16:06 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Good !!!

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

Babu
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400359 is a reply to message #229825] Mon, 27 April 2009 16:27 Go to previous messageGo to next message
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 ?

Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #400360 is a reply to message #229825] Mon, 27 April 2009 17:03 Go to previous messageGo to next message
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.
Re: How to Export/Import in Windows-Oracle10g-EnterprisesManager [message #402373 is a reply to message #229825] Sat, 09 May 2009 10:46 Go to previous message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
yes!
for my 2 yrs old question, NOW 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
Previous Topic: db shutting down while navigating enterprise manager links
Next Topic: Enterprise manager configuration failed
Goto Forum:
  


Current Time: Thu Mar 28 11:12:37 CDT 2024