OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » how to import

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

how to import [message #415191]

Sun, 26 July 2009 03:22

sfd221
Messages: 11
Registered: May 2008

Junior Member

Hi. I want to Import Dump file from ora9i to Oracle 10g r2 but I can't import (entire or by user) dump file to new data base(10g). Please Guide me

Report message to a moderator

Re: how to import [message #415204 is a reply to message #415191]

Sun, 26 July 2009 05:44

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Follow the documentation and fix what you did so that you can import.

Regards
Michel

Report message to a moderator

Re: how to import [message #415251 is a reply to message #415191]

Sun, 26 July 2009 16:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How did you do that? Which export and import utilities (versions!) did you use? What does "I can't import" mean? Any error? If so, which one?

Report message to a moderator

Re: how to import [message #415634 is a reply to message #415251]

Tue, 28 July 2009 08:17

sfd221
Messages: 11
Registered: May 2008

Junior Member

Hi
Thanks for your reply.I used the the following command:
imp SYSTEM/123@DBTEST FULL=YES ROWS=YES FILE=......
And import versions : 10.1.0.2.0
but as I forgot to set the log file path(Import terminated unsuccessfully).
After import all users was created without any data .
Sad

Report message to a moderator

Re: how to import [message #415646 is a reply to message #415634]

Tue, 28 July 2009 09:03

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Without any information we can't help.
Retry and save the log file now.

Regards
Michel

Report message to a moderator

Re: how to import [message #415653 is a reply to message #415646]

Tue, 28 July 2009 09:32

sfd221
Messages: 11
Registered: May 2008

Junior Member

Hi.
sample errors :
--------------------------------------------
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
************************************************
ORA-01918: user 'RMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ORA_MONITOR" QUOTA UNLIMITED ON "XDB""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ORA_MONITOR' does not exist
and ....

Report message to a moderator

Re: how to import [message #415655 is a reply to message #415653]

Tue, 28 July 2009 09:35

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

sample errors :

Sorry to say; I never play with oracle.

Report message to a moderator

Re: how to import [message #415663 is a reply to message #415191]

Tue, 28 July 2009 09:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Re: how to import [message #415670 is a reply to message #415653]

Tue, 28 July 2009 10:07

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Aren't these errors obvious?
Can't help more than what you posted.

Regards
Michel

Report message to a moderator

Re: how to import [message #417752 is a reply to message #415191]

Tue, 11 August 2009 07:00

sfd221
Messages: 11
Registered: May 2008

Junior Member

Hi.
Thanks for your attention. I find my answer, I have a mistake in Import job(use system user for import).

Report message to a moderator

Previous Topic:	SQL Loader .ctl script
Next Topic:	Error in loading chinese characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 19:31:29 CST 2024