Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: ext table in SYSTEM tablspace

    I have a user with no quota on the SYSTEM tablespace, and who does not have the UNLIMITED TABLESPACE system privilege. Yet, when they create an external table, oem shows that this table is placed on the SYSTEM tablespace. However, the following query:

    select owner, table_name, tablespace_name from dba_tables order by owner

    shows nothing in the tablespace_name field for this table.

    So I'm a bit confused.
    Oracle 10g
    -Chuck

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: ext table in SYSTEM tablspace

    Originally posted by chuck_forbes
    I have a user with no quota on the SYSTEM tablespace, and who does not have the UNLIMITED TABLESPACE system privilege. Yet, when they create an external table, oem shows that this table is placed on the SYSTEM tablespace. However, the following query:

    select owner, table_name, tablespace_name from dba_tables order by owner

    shows nothing in the tablespace_name field for this table.

    So I'm a bit confused.
    Oracle 10g
    -Chuck
    Beacause your table data are not stored in tablespace but direct on disk.
    More informations about external tables at http://download-west.oracle.com/docs...s.htm#i1009127

Posting Permissions

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