Re: ORA-00911 copying tables between two dbs

Tim,

thx for your help!

Daniel

Tim X <timx_at_spamto.devnul.com> schrieb im Beitrag <87hec0uyuk.fsf_at_tiger.rapttech.com.au>...
> >>>>> "News" == News <news_at_energie.rwe.de> writes:
>
> News> Hi, i tried to copy a table between two databases using
> News> following commands:
>
> News> set copycommit 1 set arraysize 1000
>
> News> copy from <user>/<password>@<db> - create attcontent - using -
> News> select * from attcontent
>
> News> ... and get the error "ORA-00911 invalid character"
>
> News> Source DB: 8.1.6 Target DB: 8.1.7 Client: "sqlplus.exe"
>
> You could try something like
>
> create database link olddb
> connect to <user>
> identified by <password>
> using <name in tnsnames>;
>
> create table tablename as
> select * from sourceTable_at_db;
>
> commit;
>
> Depending on the amount of data to be copied, you may prefer to define
> the table first to set specific options and then use insert instead.
>
> Tim
>
>
>
> --
> Tim Cross
> The e-mail address on this message is FALSE (obviously!). My real e-mail
is
> to a company in Australia called rapttech and my login is tcross - if you

> really need to send mail, you should be able to work it out!
>
Received on Fri Jan 24 2003 - 07:11:03 CST