imp user/password file=yourfile fromuser=user touser=user tables=yourtable
ignore=y commit=y log=logfile.log

imp help=y is useful.

-----Original Message-----
From: Tucker, Sharon [mailto:[Email Address Removed] Friday, November 30, 2001 8:07 AM
To: LazyDBA.com Discussion
Subject: schema level import


Help? I dropped a temp table that I shouldn't have. I have a schema level
export taken just hours before that, but I'm only interested in importing
the one table. If my memory serves me correctly, I can do that by selecting
"No" when I am asked if I want to import the entire export file.....and
providing just the name of the table I want to import.

Does this sound right? Does anyone remember if I can do this?


Sharon L. Tucker
DITMS Team
(703) 681-2417
_________________________________
"To strive, to seek, to find, and not to yield."
~ Lord Alfred Tennyson




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page