Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Table from select query-SQL/PLSQL

user9938147Mar 30 2016 — edited Apr 5 2016

Hi all,

I am trying to create a table from select query which fetches around 5000 records.The query looks like

create table xx_test

AS (SELECT col1,col2,col3

       from apps.ar_cash_receipts_all

       where org_id=12345

        and status<>'APP'

        and receipt_method_id=345)

when i try to execute it is taking hours to complete and i tried using hint PARALLEL also but no improvement.Can any one please give there valuable suggestions.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2016
Added on Mar 30 2016
19 comments
1,427 views