Skip to Main Content


SQLcl CTAS Command question

daniel_haukeAug 24 2018 — edited Aug 27 2018

Hi everybody,

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

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

This post has been answered by Glen Conway on Aug 24 2018
Jump to Answer
Post Details
Added on Aug 24 2018