Home » RDBMS Server » Server Utilities » Import oracle
Import oracle [message #242937] Tue, 05 June 2007 09:53 Go to next message
JBurch
Messages: 15
Registered: May 2007
Junior Member
I need some help on this. I am trying to import oracle database. I am importing from the same versions of oracle. After the import the application that uses the database doesn't work. and during the import the command prompt shows some errors but continues to try to import. Can someone help me import this database please
Re: Import oracle [message #242938 is a reply to message #242937] Tue, 05 June 2007 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>After the import the application that uses the database doesn't work.
Your problem statement doesn't work.
My car doesn't work.
Tell me how to fix my car.
You're On Your Own (YOYO)!

OS name & verion would help.
Oracle version to 4 decimal places would help.
Actual error codes & messages would help.
Re: Import oracle [message #242940 is a reply to message #242937] Tue, 05 June 2007 10:02 Go to previous messageGo to next message
JBurch
Messages: 15
Registered: May 2007
Junior Member
That was uncalled for... I don't know a lot about databases.
I am importing oracle 9.2.0.6.0 to 9.2.0.6.0. after the import. There is no error code. But when i open my application it opens for a second then closes. When I put the backup files in it works fine again.
Re: Import oracle [message #242946 is a reply to message #242940] Tue, 05 June 2007 10:17 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Please post the complete log of the export and the complete log of the import.

Things that COULD be wrong :

* Some tables needed for the app are missing or not filled with incorrect/inconsistend data.

* The data is in a different schema than the app expects.

* Users that the app expects are not present.

* Some functions/packages/procedures that the app needs are invalid.

* Something else entirely.

Re: Import oracle [message #243007 is a reply to message #242937] Tue, 05 June 2007 13:11 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
JBurch wrote on Tue, 05 June 2007 10:53
... and during the import the command prompt shows some errors


I don't see any errors.
Previous Topic: External Table with Sequence number
Next Topic: Auto Back Everyday at 3:30 PM
Goto Forum:
  


Current Time: Mon Jul 01 08:46:50 CDT 2024