Forum Stats

  • 3,726,730 Users
  • 2,245,248 Discussions
  • 7,852,381 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

sqlcl COPY/REPLACE implementation does not drop existing table

B.Delmée
B.Delmée Member Posts: 602 Silver Badge
edited October 2020 in SQLcl

I am using sqlcl 19.1 on RHEL 7.7. I think the implementation of the sql*plus COPY command (in its REPLACE variant) might be faulty.

The documentation says:

Replaces destination_table and its contents with the rows from query. If destination_table does not exist, COPY creates it. Otherwise, COPY drops the existing table and replaces it with a table containing the copied data.

But here's what i am getting when the destination table already exists:

Statement create table "SOME_TABLE" (...) failed, error message: ORA-00955: name is already used by an existing object

COPY_DESTINATION_WAS_NOT_CREATED.


Sign In or Register to comment.