OraFAQ Forum: Server Utilities » import not importing

Home » RDBMS Server » Server Utilities » import not importing

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

import not importing [message #73774]

Fri, 09 July 2004 06:41

jimbob
Messages: 20
Registered: April 2004

Junior Member

I have just ran into an issue using imp that I have never seen before. I imported a .dmp file...I get the message:

import terminated successfully without warnings

however, the table was not created and thus the data was not loaded. Any�suggestions?

The export was run via user OPS$ORACLE, since I was not involved in the export, I logged into my db and performed the following steps:

1) created the user OPS$ORACLE

2) granted DBA role�to OPS$ORACLE

3) ran import via: imp 'OPS$ORACLE'@mydb file=file.dmp log=imp.log fromuser='OPS$ORACLE' touser='OPS$ORACLE' rows=Y

Let me reiterate that there are no errors in my imp.log file...thanks

Report message to a moderator

Re: import not importing [message #73776 is a reply to message #73774]

Sun, 11 July 2004 05:05

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

Was the table exported? Check the export log file for confirmation, or do a "imp ... show=yes" (list the export file's contents).

Best regards.

Frank

Report message to a moderator

Previous Topic:	Using Oracle/Sql*loader to Transfer data from the textfile having lakhs of records
Next Topic:	Export error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 08:24:45 CST 2024