Home » Other » Training & Certification » schema object (merged)
schema object (merged) [message #360698] Sat, 22 November 2008 12:13 Go to next message
imraan
Messages: 21
Registered: June 2008
Location: ayangudi
Junior Member
hi my friend asked me these two questions,i don't know the answer if anyone know pls answer me

1)how to transfer the entire schema objects to other schema without performing export or import;


2)consider there is 1000 tables in the database and we have the schema level export backup only, and someone drop only one table in the database then how can we get back the particular table from the schema level export dump file(if we use ignore=y means it will import all the table but it take time, but i want only that particular table with speedy import, is it possible,or tell me other possiblities)
Re: schema object [message #360699 is a reply to message #360698] Sat, 22 November 2008 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you think the answers are?
What did you try to find the answers by yourself?

Regards
Michel
Re: schema object [message #360701 is a reply to message #360698] Sat, 22 November 2008 12:51 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't repeat your question in other topic.
But answer the one we posted you.

Regards
Michel
Previous Topic: All about Oracle Database 11g, 10g, 9i
Next Topic: To be callable from a SQL expression, a user-defined funcation must do what?
Goto Forum:
  


Current Time: Mon Aug 21 10:58:31 CDT 2017

Total time taken to generate the page: 0.06088 seconds