Re: copy certain data from one database to another

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 23 Feb 2003 19:37:11 +0200
Message-ID: <3e590623_2@news.estpak.ee>

Hi,

Richard already mentioned the QUERY parameter for exp. It's available starting from 8i (was it 8.1.6?)

The syntax is simple:

exp system/manager tables="sys.user$" query=\"where name = \'SCOTT\'\"

Tanel.

• example -----------

bash-2.03$ exp system/manager tables="sys.user$" query=\"where name = \'SCOTT\'\" Export: Release 8.1.7.1.0 - Production on Sun Feb 23 18:27:19 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production With the Partitioning option
JServer Release 8.1.7.1.0 - Production
Export done in US7ASCII character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ... Current user changed to SYS

. . exporting table                          USER$          1 rows exported

Export terminated successfully without warnings. Received on Sun Feb 23 2003 - 11:37:11 CST