Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    33

    Unanswered: sPECIFY TABLESPACE

    Hi,
    I want to know hoe you can specify the tablespace to use , when creating a table thro
    create table as select statement.

    The regular Create statement, i am specifying the table space as follows.

    CREATE TABLE eb_invoice_summary
    (debtornum NUMBER(10),
    e_invnum NUMBER(10),
    amt_inv_item NUMBER(10)
    TABLESPACE EDI_INDEX_10M_01;


    I want to know how i can specify the table space if i am creating the table thro the foll statement

    CREATE TABLE eb_invoice_detail_summary as
    SELECT a.debtornum,
    a.e_invnum,
    sum(b.amt_inv_item) amt_inv_item
    FROM eb_invoice_summary a, eb_inv_item b
    WHERE a.e_invnum = b.e_invnum
    and a.date_r >= to_date('02/10/04:01:00','mm/dd/yy:hh:mi')
    and b.date_inv_item >= '01-JAN-1000'
    GROUP BY
    a.debtornum,
    a.e_invnum


    Could anyone help me

    Thanks
    Saratha

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sPECIFY TABLESPACE

    CREATE TABLE eb_invoice_detail_summary
    TABLESPACE EDI_INDEX_10M_01 AS
    SELECT a.debtornum,
    a.e_invnum,
    sum(b.amt_inv_item) amt_inv_item
    FROM eb_invoice_summary a, eb_inv_item b
    WHERE a.e_invnum = b.e_invnum
    and a.date_r >= to_date('02/10/04:01:00','mm/dd/yy:hh:mi')
    and b.date_inv_item >= '01-JAN-1000'
    GROUP BY
    a.debtornum,
    a.e_invnum

  3. #3
    Join Date
    Nov 2003
    Posts
    33

    Thumbs up Re: sPECIFY TABLESPACE

    Originally posted by andrewst
    CREATE TABLE eb_invoice_detail_summary
    TABLESPACE EDI_INDEX_10M_01 AS
    SELECT a.debtornum,
    a.e_invnum,
    sum(b.amt_inv_item) amt_inv_item
    FROM eb_invoice_summary a, eb_inv_item b
    WHERE a.e_invnum = b.e_invnum
    and a.date_r >= to_date('02/10/04:01:00','mm/dd/yy:hh:mi')
    and b.date_inv_item >= '01-JAN-1000'
    GROUP BY
    a.debtornum,
    a.e_invnum

    Thanks Anrew,
    It worked.

    Saratha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •