mchkorg
asked on
oracle 10 : does "exp" exports indexes definition?
Easy question about oracle :)
Hi there,
I can't find an clear answer in most FAQs, wikis and so on about exp/imp in Oracle (10, if you must know):
With a "exp system/manager@mydb file=blah.exp log=blah.log full=y buffer=30000000 statistics=NONE"
=> do I export views definition?
I know "full=y" should tell me "yes, we tell you it's full!!!!", but I still have a doubt because I didn't read it on an official website and did not see a simple "exporting indexes definitions" in the export log. I just can see:
. exporting indextypes
. exporting bitmap, functional and extensible indexes
And I can read something clear about views, grants and so on. Why not something like "exporting indexes definitions"?
I must tell I didn't try to recreate from the export to check, there's a complicated story behind this :)
Thank you for your answer
Question B: when I import a single table, I suppose everything related to this table is imported/recreated? (indexes, grants...) What about views? as they might be using many several tables.
Hi there,
I can't find an clear answer in most FAQs, wikis and so on about exp/imp in Oracle (10, if you must know):
With a "exp system/manager@mydb file=blah.exp log=blah.log full=y buffer=30000000 statistics=NONE"
=> do I export views definition?
I know "full=y" should tell me "yes, we tell you it's full!!!!", but I still have a doubt because I didn't read it on an official website and did not see a simple "exporting indexes definitions" in the export log. I just can see:
. exporting indextypes
. exporting bitmap, functional and extensible indexes
And I can read something clear about views, grants and so on. Why not something like "exporting indexes definitions"?
I must tell I didn't try to recreate from the export to check, there's a complicated story behind this :)
Thank you for your answer
Question B: when I import a single table, I suppose everything related to this table is imported/recreated? (indexes, grants...) What about views? as they might be using many several tables.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thank you, I'll read this just a bit later and keep you informed
regards
Thank you, I'll read this just a bit later and keep you informed
regards
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
LOG FILE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
2) INCLUDE=VIEWS
http://www.orafaq.com/node/74