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.