Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: imp/exp question

Re: imp/exp question

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 14 Jul 2005 14:59:24 -0400
Message-ID: <42D6B60C.9030207@allegientsystems.com>


Judd, Chris wrote:

>Is there anyway to specify the import of objects other than tables? For
>example, I want import a select number of procedures, views and sequences
>from a single schema, but I do not need the entire schema.
>
>Thanks for your help,
>Chris
>--
>http://www.freelists.org/webpage/oracle-l
>
>

Chris, the best way is to export with rows=no argument and then process the export file with
DDL wizard (http://www.ddlwizard.com/). The DDL Wizard is a freeware utility which extracts
DDL commands from export file and puts them into a single file.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 14 2005 - 13:58:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US