Solved

oracle 10 : does "exp" exports indexes definition?

Posted on 2010-11-25
7
984 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:mchkorg
7 Comments
 
LVL 5

Accepted Solution

by:
Zopilote earned 32 total points
ID: 34214069
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
 
LVL 3

Assisted Solution

by:htonkov
htonkov earned 31 total points
ID: 34214488
B: views are not imported when you import a table, as you've already mentioned a reason why :)

Regards,
Hrvoje
0
 
LVL 5

Expert Comment

by:Zopilote
ID: 34214557
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 31 total points
ID: 34215316
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
 
LVL 7

Author Comment

by:mchkorg
ID: 34236982
Hi,
Thank you, I'll read this just a bit later and keep you informed

regards
0
 
LVL 5

Assisted Solution

by:anand_20703
anand_20703 earned 31 total points
ID: 34276392
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
 
LVL 7

Author Closing Comment

by:mchkorg
ID: 34281600
Thank you
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now