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