Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 24033 invoked from network); 5 Dec 2007 09:07:28 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 5 Dec 2007 09:07:28 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 187167D1F55; Wed, 5 Dec 2007 10:07:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01772-04; Wed, 5 Dec 2007 10:07:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 613C17D1F57; Wed, 5 Dec 2007 10:07:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 Dec 2007 09:20:31 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AD3F67D1CD9 for ; Wed, 5 Dec 2007 09:20:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27065-01 for ; Wed, 5 Dec 2007 09:20:31 -0500 (EST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 595257D1811 for ; Wed, 5 Dec 2007 09:20:04 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id k22so7805597waf for ; Wed, 05 Dec 2007 06:20:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=kuYSUOYMqIWBlMOU0JMvQ4e0XPWV+kSxJ2IomK7PTR8=; b=ZDyusS6odrT5yWwff5fImkcnrZ6EdzLBDHLZZSPIVy/HyjRlpMtLu3KrxtyBDfUomvMXMtWIQgR3Z481kbT/AfOJ3RK6s2Lj9bZjJzBkzTyihXJ02hWMg22WaQ7xAI8Fa8o9huI6QE7K1xm3RryGa7fDjwysWBdOp6kObn0X9tI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=IAUYo6cH0df9MEmbZbucd6sRxIG4+Nwf9al/I6X1/1huL+CNyFfRew/l9jYHPFnbsuqGjZ6lkfgql2/5gwF10K8QCjlfsKiUwq8Re7v5vj/OhMyAMrdmrH2kZdb5oEnCveQIem900FXmznVwcDaT2gYP3QjtiTq9oCEmICXlWss= Received: by 10.114.78.1 with SMTP id a1mr866086wab.1196864403173; Wed, 05 Dec 2007 06:20:03 -0800 (PST) Received: by 10.115.107.7 with HTTP; Wed, 5 Dec 2007 06:20:02 -0800 (PST) Message-ID: <7877ab4b0712050620g60e91eccs1e4b7264629eba05@mail.gmail.com> Date: Wed, 5 Dec 2007 19:50:03 +0530 From: "nilesh kumar" To: oracle-l@freelists.org Subject: exporting a tablespace MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline X-archive-position: 3714 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: nileshkum@gmail.com Precedence: normal Reply-to: nileshkum@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Hello All, A very Good Morning! I need to export a tablespace in oracle 10g. first i tried to execute dbms_tts.TRANSPORT_SET_CHECK procedure which got executed successfully then after i fired the command select * from TRANSPORT_SET_VIOLATIONS.The result of this was sys owned object object_name in tablespace tablespace_name is not allowed in pluggable state. Since it is not allowed in pluggable state i will not be allowed to export the tablespace. Is there any solution to this problem ? Thanks Nilesh -- http://www.freelists.org/webpage/oracle-l