View Full Version : Help with oracle import and export

02-14-2006, 09:20 PM
We do a nightly export of our database for backups. I'm trying to use one of these database dumps to display data that was deleted.

I am using:

imp username/pwd file=/tmp/myexport.exp show=yes rows=yes tables=ip

I basically just want to display all of the rows/records in the "ip" table. When I run that command, it displays my "create table" then creates the constraints and indexes. But it never prints out the rows. It displays the message:

. . skipping table "IP"

Which I think has something to do with it. I've tried setting indexes=no constraints=no grants=no and I get the same behavior.