I agree. Amar is correct. And it's interesting to note that way back, way way way back, during v6, we could view the export file and see the embedded "create index" commands.
-----Original Message-----
From: Kerber Andrew
[mailto:oracledba-ezmlmshield-x40630125.[Email address protected]
Sent: Wednesday, May 10, 2006 5:21 AM
To: LazyDBA Discussion
Subject: RE: Export Import of indexes
Actually, Amar P. Singh is correct. This can be determined easily by watching operations on the database. Once all the data is imported, you will see a create index command being run. There is also an import option to put the create index commands in a separate file (indexfile=) to be run later.
-----Original Message-----
From: Burns Melanie E
[mailto:oracledba-ezmlmshield-x47194717.[Email address protected]
Sent: Wednesday, May 10, 2006 7:14 AM
To: LazyDBA Discussion
Subject: RE: Export Import of indexes
Well that was helpful...
:D
-----Original Message-----
From: Hans
[mailto:oracledba-ezmlmshield-x63885259.[Email address protected]
Sent: Wednesday, May 10, 2006 2:31 AM
To: LazyDBA Discussion
Subject: RE: Export Import of indexes
You are wrong
-----Original Message-----
From: Amar P. Singh
[mailto:oracledba-ezmlmshield-x36854861.[Email address protected]
Sent: woensdag 10 mei 2006 8:26
To: LazyDBA Discussion
Subject: Export Import of indexes
Hi Gurus,
When we do a export and import of tables with indexes I think that only
the index definition is exported and not the index segment is exported.
What I mean is that if I have a table of 100 MB with 50 MB of index size
on that table. SO if I do a export with indexes then also only the 100
MB segment size of table will be exported and not the another 50 MB of
indexes segment. Only the index definition is exported and a new index
is created on the import site.
Please clarify me if I am right or wrong.
With Regards,
Amar P Singh
desk: +91 124 4167037
mobile: +91 (0) 9810788298
e-mail: [Email address protected]
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
-----------------------------------------
CONFIDENTIALITY NOTICE
This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page