SQLcl CTAS Command question

daniel_hauke

Hi everybody,

we are using Oracle SQLDeveloper Command-Line (SQLcl) version: 18.2.0.0.

I was trying to use the ctas Command to create the ddl from a table in a different tablespace. I was executing this command as sys User.

But it always throws me the following error:

SQL> ctas user1.test1 test;Create Table As Select command failed to get DDL for table "user1"

Is it not possible to use this command to create a table from different schemas? The command execute without errors when i want to create a table from my own schema.

Greetings Daniel

Glen Conway

Even when logged in as HR, if I run

SQL> ctas hr.employees hr.employees_Clone

then it returns

Create Table As Select command failed to get DDL for table "HR"

so the issue is with the CTAS command not expecting "table" or "new_table" to be provided in the form of "schema"."table".

Sounds like a bug, or at least an enhancement request.  Best to log an SR on MOS if you have an account.

Glen Conway

Even when logged in as HR, if I run

SQL> ctas hr.employees hr.employees_Clone

then it returns

Create Table As Select command failed to get DDL for table "HR"

so the issue is with the CTAS command not expecting "table" or "new_table" to be provided in the form of "schema"."table".

Sounds like a bug, or at least an enhancement request.  Best to log an SR on MOS if you have an account.

Glen Conway

In the meanwhile, check out the BRIDGE command:

daniel_hauke

Hi Glen,

thanks for the reply. I also came across the bridge command which sounds also very interessting. I will try that command.

And also i will raise an SR in MOS.

Greetings Daniel