RE: imp/exp question

I haven't tested this, but you could try exporting with rows=n and then importing that - it will still create the tables if they don't already exist, but won't load any data (set ignore=y if tables already exist). Or maybe run imp with show=y, then just get all the CREATE VIEW, CREATE PROCEDURE, etc. statements and run them as a SQL script.

Regards,
Brandon

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Judd, Chris Sent: Thursday, July 14, 2005 11:48 AM
To: oracle-l_at_freelists.org
Subject: imp/exp question

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

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

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