From oracle-l-bounce@freelists.org Fri Jul 2 18:12:52 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i62NCQG09864 for ; Fri, 2 Jul 2004 18:12:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i62NCG609854 for ; Fri, 2 Jul 2004 18:12:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6FBA472C2D0; Fri, 2 Jul 2004 17:54:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16019-32; Fri, 2 Jul 2004 17:54:22 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B555F72C1D5; Fri, 2 Jul 2004 17:54:21 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Jul 2004 17:52:59 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7702972C1D6 for ; Fri, 2 Jul 2004 17:52:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16019-11 for ; Fri, 2 Jul 2004 17:52:58 -0500 (EST) Received: from blockhead.mincom.com (blockhead1.mincom.com [203.202.173.251]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 341DA72C11F for ; Fri, 2 Jul 2004 17:52:57 -0500 (EST) Received: (from uucp@localhost) by blockhead.mincom.com (8.9.3/8.9.3) id JAA22669 for ; Sat, 3 Jul 2004 09:15:58 +1000 (EST) (envelope-from graeme.farmer@mincom.com) Received: from bnepms01.mincom.oz.au(172.17.65.84) via SMTP by blockhead.mincom.oz.au, id smtpdd22660; Sat Jul 3 09:15:56 2004 Received: from TQXBNECLU03.root.tequinox.com (unverified [172.31.4.22]) by bnepms01.mincom.oz.au (Content Technologies SMTPRS 4.3.14) with ESMTP id for ; Sat, 3 Jul 2004 09:15:57 +1000 Received: by tqxbneclu03.root.tequinox.com with Internet Mail Service (5.5.2657.72) id ; Sat, 3 Jul 2004 09:15:56 +1000 Message-ID: From: Graeme Farmer To: "'oracle-l@freelists.org'" Subject: RE: Tablespaces Date: Sat, 3 Jul 2004 09:15:55 +1000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4392 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: graeme.farmer@mincom.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Balu, I'd suggest that you consder the "alter table . move tablespace " and "alter index . rebuild tablespace " statements, they will make the job far simpler. Make sure you move the tables before rebuilding the indexes as the table move necessarily invalidates the related indexes. Otherwise, with exp/imp you would export a schema at a time, use "indexfile=" on the first import, edit the file to change the tablespace names, pre-create the tables from this DDL, load the data with "ignore=y" then build the indexes add constraints with the remainder of the parsed DDL. You can see why it is easier to use "alter table move" and "alter index rebuild" statements!! Cheers, Graeme. -----Original Message----- From: Computer Centre - NIIPL [mailto:compute@ponyneedles.com] Sent: Friday, 2 July 2004 6:41 PM To: Oracle Mailing List Subject: Tablespaces Dear All, In our test database we are having one tablespace. The tablespace contains all the tables for different users. ( 1200 Tables). We would like to have a separate tablespace for each user in the real time database.If we use the exp/imp utility, the table will be created in same tablespace as of the original one. Is there any way to insert the tables in to the newly created tablespaces while using imp utility. Please help us. Regards, Balu This mail is scaned by eScan Anti Virus Software ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------