title: `CREATE TABLE AS SELECT FROM` in Oracle Cloud doesn't create a new table
body: <p>I was trying to create a series of tables in a single SQL query in Oracle Cloud under the ADMIN account. In the minimum script below, <code>RAW_TABLE</code> refers to an existing table.</p>
  <pre><code>CREATE TABLE BASE1 AS SELECT * FROM RAW_TABLE;
  CREATE TABLE BASE2 AS SELECT * FROM BASE1;
  CREATE TABLE BASE3 AS SELECT * FROM BASE2;
  SELECT * FROM BASE3
  </code></pre>
  <p>This returns a view of the first 100 rows in <code>BASE3</code>, but it doesn't create the three tables along the way. Did I miss something or is there something peculiar about <code>create table</code> statements in Oracle SQL?</p>
  <p>EDIT: <strong>The environment is Oracle Database Actions in Oracle Cloud</strong>. The three tables would not be available in the list of tables in the database, and doing something like <code>select * from BASE3</code> in a subsequent query would fail.</p>