From oracle-l-bounce@freelists.org Tue Jul 13 09:52:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6DEq7125181 for ; Tue, 13 Jul 2004 09:52:17 -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 i6DEpu625142 for ; Tue, 13 Jul 2004 09:52:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D37F72DC32; Tue, 13 Jul 2004 09:32:14 -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 27439-97; Tue, 13 Jul 2004 09:32:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2A59572DD43; Tue, 13 Jul 2004 09:31:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Jul 2004 09:30:14 -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 3222C72DC8D for ; Tue, 13 Jul 2004 09:30:13 -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 27827-01 for ; Tue, 13 Jul 2004 09:30:12 -0500 (EST) Received: from cent20000.tfmc.co.za (unknown [196.22.177.99]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6525772D7AB for ; Tue, 13 Jul 2004 09:30:04 -0500 (EST) Received: from Cent12000.tfmc.co.za (Not Verified[172.21.6.21]) by cent20000.tfmc.co.za with NetIQ MailMarshal (v5.5.4.16) id ; Tue, 13 Jul 2004 16:57:11 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: imp issue...very confusing! Date: Tue, 13 Jul 2004 16:57:02 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: imp issue...very confusing! Thread-Index: AcRo5l0ppFH0401nSfmGYKEOdevAGAAACn6QAAB26iA= From: "Denham Eva" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4961 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: EVAD@TFMC.co.za Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Thanks Ron for the input, I am going to investigate this issue. Regards Denham -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Smith, Ron L. Sent: Tuesday, July 13, 2004 4:37 PM To: oracle-l@freelists.org Subject: RE: imp issue...very confusing! I found that when I give a user (touser) unlimited tablespace on his/her own tablespace, for some reason the user also gets granted unlimited tablespace on all tablespaces. When that happens, the fromuser touser option results in all the objects getting put back into the fromuser tablespace. When I revoke unlimited tablespace, the import works fine. Ron Smith ---------------------------------------------------------------- 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 -----------------------------------------------------------------