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.
LVL 7
mchkorgAsked:
Who is Participating?
 
ZopiloteConnect With a Mentor Commented:
From Ver. 10g Oracle is recommending to use Data Pump Export and Import tools, which are enhanced versions of original Export and Import tools.

The export dump file contains objects in the following order:

   1. Type definitions
   2. Table definitions
   3. Table data
   4. Table indexes
   5. Integrity constraints, views, procedures, and triggers
   6. Bitmap, function-based, and domain indexes

http://www.oracle-dba-online.com/export_and_import.htm
0
 
htonkovConnect With a Mentor Commented:
B: views are not imported when you import a table, as you've already mentioned a reason why :)

Regards,
Hrvoje
0
 
ZopiloteCommented:
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
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
sdstuberConnect With a Mentor Commented:
exporting a table (whether by full or listed object) will get the indexes, constraints, triggers and grants for that table.

Note, that doesn't guarantee successful import though.  Constraints or triggers that reference objects not imported will be invalid.

Grants to users or roles that don't exist won't be applied
0
 
mchkorgAuthor Commented:
Hi,
Thank you, I'll read this just a bit later and keep you informed

regards
0
 
AnandConnect With a Mentor Commented:
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.
--- everything related to table will not be imported. i.e, plsql objects, views will not be imported.
    if u want to import everything related to one table, go for schema import. i.e, owner=schemaname. this will bring all the objects including plsql objects,view,indexes,tables,grants...
0
 
mchkorgAuthor Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.