Re: SQL*Plus COPY command

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 14 Jul 2005 07:49:33 +0200
Message-ID: <db4ucm$u89$00$1@news.t-online.com>

Ken wrote:
> "Maxim Demenko" <mdemenko_at_gmail.com> 在郵件
> news:db2di9$1e7$03$1_at_news.t-online.com 中撰寫...
>

>>Ken wrote:
>>
>>>Maxim,
>>>
>>>Is it a command or utility?  I could not locate its information when
>>>searching Tahiti!
>>>
>>>Thx
>>>"Maxim Demenko" <mdemenko_at_gmail.com> 在郵件
>>>news:davp67$mtb$05$1_at_news.t-online.com 中撰寫...
>>>
>>>
>>>>Ken wrote:
>>>>
>>>>
>>>>>Hi,
>>>>>
>>>>>The manual says the COPY command is going to be obsoleted.  I am just
>>>>>wondering what else we can use
>>>>>to achieve the same function.
>>>>>
>>>>>Thx
>>>>>
>>>>>
>>>>
>>>>Datapump
>>>>
>>>>Best regards
>>>>
>>>>Maxim
>>>
>>>
>>>
>>Hi, Datapump is new technology in 10g that comes to extend exp/imp
>>capabilities in prior releases, here is the link
>>

>
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/part_dp.htm#i436481
>

>>Best regards
>>
>>Maxim
>>

>
> Maxim,
>
> Do you know anything with similar functionality in Oracle 9iR2?
>
> Thx
>
>

In most cases CREATE TABLE AS SELECT should cover the COPY functionality, for the rest - exp/imp.

Best regards

Maxim Received on Thu Jul 14 2005 - 00:49:33 CDT