Link to home
Start Free TrialLog in
Avatar of mchkorg
mchkorgFlag for France

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.
ASKER CERTIFIED SOLUTION
Avatar of Zopilote
Zopilote
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
1) The interesting point to notice when issuing these commands is to take a close look at the export logs for each of these export modes. When taking a full schema export you will notice that the export pulls out various additional object types such as grants, roles, sequences, and views.

LOG FILE
Processing object type SCHEMA_EXPORT/VIEW/VIEW

2) INCLUDE=VIEWS
http://www.orafaq.com/node/74
SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mchkorg

ASKER

Hi,
Thank you, I'll read this just a bit later and keep you informed

regards
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mchkorg

ASKER

Thank you