title: Oracle SQL CREATE TABLE takes too long time or not able to create (without CREATE TABLE works)
body: <p>Any one can give some input here. </p>
  
  <p>I am using this structure to create the table, </p>
  
  <pre><code>create table user.sales_fill as
  select
          a.name
          ,gender
          ,a.age
          ,b.sales
          , 1 as logic
  from
            (select distinct
                                name, age, gender
               from cust_info                 )a
            left join
                      sales b
                      on
                                a.age  = b.age
                                and a.gender = b.gender
   ;
  </code></pre>
  
  <p>when I only use the SELECT part it only takes 7.5seconds to showing the results.</p>
  
  <pre><code> select
              a.name
              ,gender
              ,a.age
              ,b.sales
              , 1 as logic
      from
                (select distinct
                                    name, age, gender
                  from cust_info
                                    )a
                left join
                          sales b
                          on
                                    a.age  = b.age
                                    and a.gender = b.gender
       ;
  </code></pre>
  
  <p>but if i Add 'create table' on top of the this select code. I never able to get the table created. </p>
  
  <p>i have right to create the table if i use the the following the table created (but not the right content)</p>
  
  <pre><code>create table user.sales_fill as  
  select
  
                  gender
                  ,age
                  ,sales
                  , 1 as logic
          from  sales 
           ;
  </code></pre>
  
  <p>Any suggestion? Thank you!</p>