Where Constraints gets stored
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Where Constraints gets stored

  1. #1
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    I am trying to design an application. The application tables will have their respective tablespaces. All the tables will be stored only in their respective tables. None of them will go to SYSTEM or USERS tablepaces.

    But when I create the user, I issue these commands

    create user TEMP identified by temp
    default tablespace users
    temporary tablespace temporary;

    then

    alter user temp quota 0 to system;

    alter user TEMP quota 0 to users;

    The basic idea is , I don't want the user TEMP to take any space from USERS tb or SYSTEM tb. Is it OK. And what happens to all CONSTRAINTS. Where do they go. All Index's also will automatically go to respective index tb.
    Thanks
    Kishore Kumar

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking huh??


    ok now you are definately confusing me.
    a User that cannot use any space? Why would you want a user called TEMP?

    - Magnus

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    What I am trying to explain is..

    All the scripts I create to in the User TEMP, will take the tablespace like Appl1, Index1. I want to spare USERS tablespace from my application tables.

    Typically I create the table this way
    create table app( account char)
    tablespace appl1;

    I think it gives more clear idea.
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    blabla

    Only segments (tables, indexes, clusters, MVs, ...) as user objects are physicaly stored in a designated tablespaces. All other user's stuff (constraints, comments, PL/SQL code, views, etc etc ....) gets stored in a SYSTEM tablespace in a database dictionary tables owned by SYS, so the user does not need (and should never have been granted) any quota on SYSTEM tablespace.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Thanks
    Thanks
    Kishore Kumar

Posting Permissions

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


Click Here to Expand Forum to Full Width