|| at Jul 14, 2005 at 1:58 pm
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.
On Behalf Of Judd, Chris
Sent: Thursday, July 14, 2005 11:48 AM
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,
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.