Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Importing a lost table

Importing a lost table

Importing a lost table

I have to import a lost table.
I am using Oracle 8.0.5.
I used the import utility to import the table. It said that it imported the table from the system objects into the
username successfully without warnings, but when I check the USER_TABLES, the table that I supposidly imported over, does not show.
This is how I did it:

c:> imp80 system/manager@rms
EXPDAT.DMP > e:\rms export\rms.dmp
Import entire file > n
Username: Central
Enter table name<T> or partition<T:P> or . if done > mvc_file

. . importing system objects into Central..

Import successfully without warnings

This is how I did it and for some reason the table that was imported does not show.
Can someone tell me why and how can I recover this table. ASAP!!

Please & thanks

RE: Importing a lost table

I think that you will find that you imported the object into the SYSTEM users schema. If you want to import into CENTRAL you need to either run the import under that userid
(imp80 central/password@rms) or use the FROMUSER parameter to specify the user central. You can also add TOUSER but since you are not changing schemas I do not think that this is needed.

imp80 system/manager@rms file=export.dmp fromuser=central ... (any other parameters)

You can check this out in the 'Oracle8 Utilities' manual.

RE: Importing a lost table

As a debugging technique, you could also perform the import with SHOW=Y to see the SQL syntax of what the imp is really doing.

My guess is that the imp you did didn't import any rows, or you would have gotten the message:
. . importing table "MVC_FILE" n rows imported

Is it possible that the table didn't exist in the .dmp file?

RE: Importing a lost table

You may have inavertantly imported to a different owner. log on as system or sys with the schema manager and search all the schemas for the correct table. export that table via the owner and import signed on as the actual owner of the table

RE: Importing a lost table

You login as System/Manager you can find your imported

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close