Xref: alice comp.databases.oracle.misc:52421
Path: alice!news-feed.fnsi.net!enews.sgi.com!harbinger.cc.monash.edu.au!news.mel.connect.com.au!news.syd.connect.com.au!nsw.nnrp.telstra.net!newsfeeds.bigpond.com!not-for-mail
From: "Graeme Farmer" <g_farmer@halas.com.au>
Newsgroups: comp.databases.oracle.misc
Subject: export / import
Lines: 12
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <te5m4.5588$VJ1.9448@newsfeeds.bigpond.com>
Date: Thu, 3 Feb 2000 13:02:34 +1100
X-Trace: newsfeeds.bigpond.com 949542937 203.40.25.213 (Thu, 03 Feb 2000 12:55:37 EST)
NNTP-Posting-Date: Thu, 03 Feb 2000 12:55:37 EST
Organization: Telstra BigPond Internet Services (http://www.bigpond.com)

Is it possible to export/import (for re-org) data only leaving the indexes
intact? When you drop a table it also drops any indexes associated with it
so would I be correct in assuming that you perform the export, truncate the
tables then import the data or does the truncate command also kill the
indexes. I don't have enough of a window at the weekend to export/import
both data and rebuild of indexes.

Thanks
Graeme.