Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00911 copying tables between two dbs

ORA-00911 copying tables between two dbs

From: News <news_at_energie.rwe.de>
Date: Wed, 22 Jan 2003 15:29:18 +0000 (UTC)
Message-ID: <01c2c22b$0872d1c0$708116ac@a0200846>


Hi,

i tried to copy a table between two databases using following commands:

set copycommit 1
set arraysize 1000

copy from <user>/<password>@<db> -
create attcontent -
using -
select * from attcontent

... and get the error "ORA-00911 invalid character"

Source DB:	8.1.6
Target DB:	8.1.7
Client: 		"sqlplus.exe"

Thx for help
Daniel Received on Wed Jan 22 2003 - 09:29:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US