Re: how to use exp/imp only for specific columns?

Ok good - that helps

You could produce a simple flat file from the 8.1.7 source database and declare that file once on the target system as an External Table. This defines the structure of the table in the dictionary but allows the data to be stored in a flat file on the OS.

The only thing I am not sure of is the performance. By the way the External table will by definition be read only. Check out to SQL Reference Manual for 9i

Does that help.

Regards Kevin
"Andreas Lederer" <Andreas.Lederer_at_tecco.at> wrote in message news:4061a39e$1_at_e-post.inode.at...
That differs, e.g. 8.1.7 and 9.2

andreas

Kevin A Lewis schrieb:

> What Oracle DB versions are each of these databases (source and target)
>
> Regards Kevin
> "alederer" <alederer_at_gmx.at> wrote in message
> news:40619df6$1_at_e-post.inode.at...
> The problem is, that the two databases are on different sites which are
> connected via a small bandwith line.
>
> so i don't want to move large amount of data (e.g. 17 GB) between these
> databases.
>
> is it possible to make a database link which compresses the data?
>
> thanks
> andreas
>
> Kevin A Lewis schrieb:
>
>
>>Have you considered setting up a Database Link - to enable a single piece
>
> of
>
>>SQL to know about two Oracle Databases (even two different version :
>
> albeit
>
>>with limits)
>>
>>You can then update (INSERT, UPDATE or DELETE) based on data read in the
>>source database.
>>
>>Does this help! Not sure why you needed the file based approach.
>>
>>Regards Kevin
>>"alederer" <alederer_at_gmx.at> wrote in message
>>news:406194de$1_at_e-post.inode.at...
>>Michel Cadot schrieb:
>>
>>
>>>"alederer" <alederer_at_gmx.at> a écrit dans le message de
>>
>>news:40616570$1_at_e-post.inode.at...
>>
>>
>>>>hallo!
>>>>
>>>>i have for example the following situation:
>>>>
>>>>a table on site a tab1(a_key integer,
>>>> a_val1 varchar(500),
>>>> a_val2 varchar(1000))
>>>>
>>>>and a table on site b tab2((b_key integer,
>>>> b_val2 varchar(1000),
>>>> b_val3 integer)
>>>>
>>>>is it possible to use the export/import utility or the sql loader to
>>>>transfer only the data of the columns a_key and a_val2 from tab1 to
>>>>tab2(into b_key, b_val2)?
>>>>
>>>>in the documentation of export, i have only found the QUERY parameter,
>>>>but it can only limit the rows not the columns which should be exported.
>>>>
>>>>if i have a direct database connection i can use
>>>>"insert into tab2(b_key,b_val2) (select a_key, a_val2 from tab1)"
>>>>
>>>>but how can a make this with export/import utility or sql loader?
>>>>
>>>>what i need is a way to export only specific columns of a table and to
>>>>import these export into tables with different column names and order.
>>>>
>>>>where can i find the missing information?
>>>>
>>>>thanks
>>>>andreas
>>>
>>>
>>>You can execute your first query with SQL*Plus and spool the result in a
>>
>>file
>>
>>
>>>which can be loaded with SQL*Loader.
>>>
>>
>>
>>I see the following problems:
>>* I need to make the export/spool within a c++ application, ok i can
>> call a external process which make the work.
>>* because the application is generic, i don't know what data is in the
>> table columns, so what termination character should i use for the
>> sqlldr control section
>>
>>i have downloaded the sqlldr_exp skripts from
>>http://asktom.oracle.com/~tkyte/flat/index.html
>>but these have some limits.
>>* what about the limit, that one row/line is limited to 4000 characters,
>>how can i do larger exports/spools?
>>* what about newline characters in the column data?
>>
>>Why is it so complicated in oracle to transfer data via files from one
>>database to another, between different database versions ?
>>Is there no way like in db2 where the export recognizes a select
>>statement, the data is dumped to ixf file format which can be used on
>>all plattforms and on the load site, you can specify a different order
>>for the columns to load from the ixf file. I do not need to worry about
>>a termination character.
>>
>>thanks
>>andreas
>>
>>
>
>
>
Received on Wed Mar 24 2004 - 09:08:11 CST