View Poll Results: Using CREATE TABLE AS SELECT IS DANGEROUS

Voters
4. You may not vote on this poll
  • Yes because the data space would be desorganised

    0 0%
  • Yes because the dictionnary of Oracle is not able to supprt it

    0 0%
  • No it is a normal way of using Oracle

    3 75.00%
  • Yes because in my experience the result is the Chaos

    1 25.00%
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Question Unanswered: System Table space reorganization

    After many experiences on Oracle the DBA Team of one of my client said :
    'You have made an application using dynamic tables created by
    CREATE TABLE AS SELECT
    Making such a thing is very dangerous because we are sure that in a few months the SYSTEM TABLESPACE would be desorganized and the entire database would be unusable'

    These 'temporary dynamic tables' are created and removed on a daily base frequency.

    I have, with my long experience on Oracle, to reply that, yes it is a risk but I have never seen such a chaotic scenario.

    Is there some one who experienced the chaotic situation predicted

    Thank You for your Help

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

    Re: System Table space reorganization

    Originally posted by NewComer
    After many experiences on Oracle the DBA Team of one of my client said :
    'You have made an application using dynamic tables created by
    CREATE TABLE AS SELECT
    Making such a thing is very dangerous because we are sure that in a few months the SYSTEM TABLESPACE would be desorganized and the entire database would be unusable'

    These 'temporary dynamic tables' are created and removed on a daily base frequency.

    I have, with my long experience on Oracle, to reply that, yes it is a risk but I have never seen such a chaotic scenario.

    Is there some one who experienced the chaotic situation predicted

    Thank You for your Help
    I could not select an option from your poll, because none seemed appropriate for me, but certainly creating temporary tables in your application is very much to be avoided in Oracle. The man who can best explain this is Tom Kyte - see this:

    http://asktom.oracle.com/pls/ask/f?p...D:604830985638

    Oracle's "global temporary" tables are the way to go.

Posting Permissions

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