Home » RDBMS Server » Server Utilities » how to import
how to import [message #415191] Sun, 26 July 2009 03:22 Go to next message
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
Re: how to import [message #415204 is a reply to message #415191] Sun, 26 July 2009 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the documentation and fix what you did so that you can import.

Regards
Michel
Re: how to import [message #415251 is a reply to message #415191] Sun, 26 July 2009 16:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: how to import [message #415634 is a reply to message #415251] Tue, 28 July 2009 08:17 Go to previous messageGo to next message
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
Re: how to import [message #415646 is a reply to message #415634] Tue, 28 July 2009 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without any information we can't help.
Retry and save the log file now.

Regards
Michel
Re: how to import [message #415653 is a reply to message #415646] Tue, 28 July 2009 09:32 Go to previous messageGo to next message
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 ....

Re: how to import [message #415655 is a reply to message #415653] Tue, 28 July 2009 09:35 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
sample errors :


Sorry to say; I never play with oracle.
Re: how to import [message #415663 is a reply to message #415191] Tue, 28 July 2009 09:47 Go to previous messageGo to next message
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.
Re: how to import [message #415670 is a reply to message #415653] Tue, 28 July 2009 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Aren't these errors obvious?
Can't help more than what you posted.

Regards
Michel
Re: how to import [message #417752 is a reply to message #415191] Tue, 11 August 2009 07:00 Go to previous message
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).
Previous Topic: SQL Loader .ctl script
Next Topic: Error in loading chinese characters
Goto Forum:
  


Current Time: Thu Mar 28 04:58:54 CDT 2024