Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL*PLUS-Substitute for COPY command

Status
Not open for further replies.
pdtt

pdtt

Programmer
Sep 24, 2002
35
CA
Hi,

I am trying to move large amounts of data from one oracle db to another. Tablespace moves are not useful. I have been instructed to use the COPY commmand. It is working well for tables that do not have FLOAT datatype. However it errors on those tables with FLOATS. Oracle documentation states that FLOATS are not supported by the COPY command.

Is there a newer SQL*PLUS command that supersedes the COPY command or what would be the best way to mimic the behavior of the COPY command to move tables with FLOAT datatypes?
 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
892
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
483
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
366
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top