Home » RDBMS Server » Enterprise Manager » Exporting Schema
icon9.gif  Exporting Schema [message #251213] Thu, 12 July 2007 13:04 Go to next message
brad_san
Messages: 4
Registered: July 2007
Location: San Diego
Junior Member

Novice Oracle user...I am using 10.2.0.2 on Windows Server2003. I'm trying to export a schema in my DB using Enterprise manager (Maintenance>Export to Export file). When I enter valid HOST NAME and HOST PASSWORD for the machine I always get "Validation Error", enter correct password. I've tried about every combination I can thing of including DOMAIN\UserName, username, etc.

I have administrator privileges on the machine. What is not working and how do I fix it? I need to get this export to send to a Java tech so he can help me with a programming issue I am having. Auuuugh!

Brad
Re: Exporting Schema [message #251217 is a reply to message #251213] Thu, 12 July 2007 13:06 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
you should set HOST CREDENTIALS

Go to "Control Panel" -> "Admin Tools" -> "Local Security Policy."
Within "Local Policies", go to user "Right Assignment."
Add the user to "Logon as a Batch Job."
The logon problem should now be resolved. This is for trying to run Oracle 10g on Windows 2003 Server.

icon9.gif  Re: Exporting Schema [message #251248 is a reply to message #251217] Thu, 12 July 2007 14:11 Go to previous messageGo to next message
brad_san
Messages: 4
Registered: July 2007
Location: San Diego
Junior Member

Ok, that works, but now, DURING the export process it asks for a directory to be set. When I try to set it as SYSOPER it says I don't have sufficient privileges. When I log in as SYSDBA is says SYSDBA can't perform export functions in 10g. Now what?
Re: Exporting Schema [message #251251 is a reply to message #251248] Thu, 12 July 2007 14:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
try another user which have privilege EXP_FULL_DATABASE.

In 10g you should need directory for datapump IMPDP/EXPDP as well.

[Updated on: Thu, 12 July 2007 14:17]

Report message to a moderator

Re: Exporting Schema [message #251254 is a reply to message #251251] Thu, 12 July 2007 14:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> create directory exports as '/export/home/oracle/';

Directory created.

SQL> grant read,write on directory exports to oracle;

Grant succeeded.
SQL> grant exp_full_database to oracle;

Grant succeeded.



After this you should be able to use DATAPUMP.
Re: Exporting Schema [message #251265 is a reply to message #251213] Thu, 12 July 2007 14:48 Go to previous messageGo to next message
brad_san
Messages: 4
Registered: July 2007
Location: San Diego
Junior Member

Ok, both of those I think are helpful, but here is the error I get as I run the process:

Export Submit Failed
ORA-20204: User does not exist: SDE ORA-06512: at "SYSMAN.MGMT_USER", line 122 ORA-06512: at "SYSMAN.MGMT_JOBS", line 139 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1

My user in this case is "SDE" (I amended the SQL statements you sent to use the SDE user rather than the oracle user).

Seems I am very close, but not quite there yet. Today has been a good Oracle learning eaperience, though!

Thanks for your help to this point...

Brad
Re: Exporting Schema [message #251277 is a reply to message #251265] Thu, 12 July 2007 15:24 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check this forum for the error you got

http://forums.oracle.com/forums/thread.jspa?messageID=1396456
icon10.gif  Re: Exporting Schema [message #251291 is a reply to message #251213] Thu, 12 July 2007 16:15 Go to previous messageGo to next message
brad_san
Messages: 4
Registered: July 2007
Location: San Diego
Junior Member

Yay!

That last little bit helped, though I'm sure my SDE user has way more privileges in the DB than he should now, but since I am all of those roles...no worries.

Thanks TONS for the help! I can now send this schema off and try to get my Java issue solved.

Brad
Cool
Re: Exporting Schema [message #251292 is a reply to message #251291] Thu, 12 July 2007 16:18 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you solve problem?
Yow welcome Wink
Previous Topic: em
Next Topic: ora 00018
Goto Forum:
  


Current Time: Thu Mar 28 05:32:28 CDT 2024