oracle 10 : does "exp" exports indexes definition?
Posted on 2010-11-25
Easy question about oracle :)
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.