Import oracle [message #242937] |
Tue, 05 June 2007 09:53 |
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 #242940 is a reply to message #242937] |
Tue, 05 June 2007 10:02 |
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 |
ThomasG
Messages: 3212 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 |
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.
|
|
|