Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
02-14-2006, 09:20 PM #1
- Join Date
- Jan 2003
- Thanked 8 Times in 8 Posts
Help with oracle import and export
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.