Solved

oracle 10 : does "exp" exports indexes definition?

Posted on 2010-11-25
7
981 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

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.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Number Format 1 44
Oracle Syntax 8 41
Wrap Oraccle SQL*Plus executable Command 4 35
ORA-12560: TNS:protocol adapter error 8 48
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 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

21 Experts available now in Live!

Get 1:1 Help Now