Create table tablespace as select

1. Does CREATE TABLE as select create indexes?
2. How to create table with default tablespace in Oracle?

Does CREATE TABLE as select create indexes?

CREATE TABLE ... SELECT does not automatically create any indexes for you. This is done intentionally to make the statement as flexible as possible.

How to create table with default tablespace in Oracle?

To set the default permanent tablespace in Oracle, you can run the following ALTER DATABASE statement: ALTER DATABASE DEFAULT TABLESPACE tbs_perm_01; This will update the default permanent tablespace to use the tbs_perm_01 tablespace.