OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » Exporting Schema

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

Exporting Schema [message #251213]

Thu, 12 July 2007 13:04

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

Report message to a moderator

Re: Exporting Schema [message #251217 is a reply to message #251213]

Thu, 12 July 2007 13:06

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.

Report message to a moderator

Re: Exporting Schema [message #251248 is a reply to message #251217]

Thu, 12 July 2007 14:11

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?

Report message to a moderator

Re: Exporting Schema [message #251251 is a reply to message #251248]

Thu, 12 July 2007 14:13

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

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.

Report message to a moderator

Re: Exporting Schema [message #251265 is a reply to message #251213]

Thu, 12 July 2007 14:48

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

Report message to a moderator

Re: Exporting Schema [message #251277 is a reply to message #251265]

Thu, 12 July 2007 15:24

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

Report message to a moderator

Re: Exporting Schema [message #251291 is a reply to message #251213]

Thu, 12 July 2007 16:15

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

Report message to a moderator

Re: Exporting Schema [message #251292 is a reply to message #251291]

Thu, 12 July 2007 16:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you solve problem?
Yow welcome Wink

Report message to a moderator

Previous Topic:	em
Next Topic:	ora 00018

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:20:07 CST 2024