Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    23

    Unanswered: indexes on Oracle Temporary Tables

    Can indexes be created on oracle temporary tables under certain conditions? If yes can you provide me with details. I've set up a table using the create global statement but I'm not permitted to apply an index

    thanks

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    see create index in the sql manual :

    If table is a temporary table, the index will also be temporary with the same scope (session or transaction) as table. The following restrictions apply to indexes on temporary table:

    The index cannot be a partitioned index or a domain index.

    You cannot specify the physical_attributes_clause or the parallel_clause.

    You cannot specify LOGGING, NOLOGGING, or TABLESPACE.

    See Also: CREATE TABLE and Oracle8i Concepts for more information on temporary tables

    Alan

Posting Permissions

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