Go Back   CodingForums.com > :: Server side development > MySQL > Other Databases

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 02-14-2006, 08:20 PM   PM User | #1
arnyinc
Regular Coder

 
Join Date: Jan 2003
Posts: 867
Thanks: 4
Thanked 8 Times in 8 Posts
arnyinc is an unknown quantity at this point
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.
arnyinc is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 01:38 PM.


Advertisement
Log in to turn off these ads.