Working with 2 schemas

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 6 Aug 2002 11:30:54 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70277F826@lnewton.leeds.lfs.co.uk>

Pavel,

in a word, 'no'.

You can export the structure without the data, but the export file always contains a CREATE TABLE script for the tables and a load if data to INSERT into it.
If you have the tables already created in another schema (or database) then simply set IGNORE=Y on the *imp* and if the table exists, the data will be imported into it, if it does not exist, it will be created first and imported.

Watch out if the table exists but has a different structure - you will hit ORA-00904 import errors (Invalid column name).

HTH Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Paweł [mailto:pawel_at_millionzillion.com.pl] Posted At: Tuesday, August 06, 2002 6:46 AM Posted To: server
Conversation: Working with 2 schemas
Subject: Re: Working with 2 schemas

Is there an option in export to export only data without table definition?

Pawel Received on Tue Aug 06 2002 - 05:30:54 CDT