Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!newscon06.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr15.news.prodigy.com.POSTED!not-for-mail From: "Steve" Newsgroups: comp.databases.oracle.server Subject: Import Help! Lines: 14 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: NNTP-Posting-Host: 64.48.75.25 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr15.news.prodigy.com 1002757805 ST000 64.48.75.25 (Wed, 10 Oct 2001 19:50:05 EDT) NNTP-Posting-Date: Wed, 10 Oct 2001 19:50:05 EDT Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: TSU[@I_AOXZU@B\]@CCDN_HAQB^H@IPDLXUNNHLHQAVTUZ]CLNTCPFK[WDXDHV[K^FCGJCJLPF_D_NCC@FUG^Q\DINVAXSLIFXYJSSCCALP@PB@\OS@BITWAH\CQZKJMMD^SJA^NXA\GVLSRBD^M_NW_F[YLVTWIGAXAQBOATKBBQRXECDFDMQ\DZFUE@\JM Date: Wed, 10 Oct 2001 23:50:05 GMT Xref: easynews comp.databases.oracle.server:120878 X-Received-Date: Wed, 10 Oct 2001 17:09:55 MST (news.easynews.com) Hi, Is there anyway to have database data and index imported to different tablespaces at the same time? Currently I am importing data only one time, getting index info into a sql file, changing tablespace name then exec this sql as the next time. It is grateful if someone share his greate idea. Steve