DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Problem with Tablespace

  1. #1
    Join Date
    Mar 2003
    Location
    India
    Posts
    3

    Question Problem with Tablespace

    Hi,
    I've created a user (Oracle 8i)from user name = system & Pwd = Manager

    create user user_name
    identified by pwd

    and given the following privillages to the created user:

    connect, resource, create session, create table

    when i create a table in my new user it gives the ERROR :

    no privillages on tablespace 'SYSTEM'

    why it is giving this error. Do i need to create a tablespace for it.
    If yes how can i create it. Help Please

    Thanks in anticipation.
    Jaya

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Look up create user command in the documentation. Find out what the default tablespaces are for a user. Then look at your create user statement and see what you did or didn't do with respect to assigning a default tablespace. Look at dba_users table to confirm what you find out in the documentation. You will be needing the alter user statement after that.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    create tablespace users datafile 'path\user01.dbf' size xK or (M)
    (autoextend cluase)
    extent_management local
    uniform

    while creating user assign this tablespace to that user.


    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by stecal
    Look up create user command in the documentation. Find out what the default tablespaces are for a user. Then look at your create user statement and see what you did or didn't do with respect to assigning a default tablespace. Look at dba_users table to confirm what you find out in the documentation. You will be needing the alter user statement after that.
    Exactly!!

    You may also want to look at DBA_SEGMENTS and DBA_USERS and insure that there are no other structures and users using the SYSTEM tablespace.

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by abhaysk
    create tablespace users datafile 'path\user01.dbf' size xK or (M)
    (autoextend cluase)
    extent_management local
    uniform

    while creating user assign this tablespace to that user.


    Abhay.
    Thanks for the input. You can spoonfeed this guy or teach him how to fish. Don't you think the point of what I wrote was geared toward helping him learn some of this on his own? Isn't the use (or non-use) of the system tablespace one of the most fundamental design concepts, and what an easy thing to look up and learn for yourself.

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by stecal
    Thanks for the input. You can spoonfeed this guy or teach him how to fish. Don't you think the point of what I wrote was geared toward helping him learn some of this on his own? Isn't the use (or non-use) of the system tablespace one of the most fundamental design concepts, and what an easy thing to look up and learn for yourself.
    Stecal:
    i didnt c ur post..coz i blv we poseted almost at same time...

    and as far as SYSTEM tablespace is concerned...it shud not be granted to users ... n this is basics... i thought he/she wud hav known....

    why it is giving this error. Do i need to create a tablespace for it.
    If yes how can i create it. Help Please
    this is wat one of the things jaya asked for ... so thought wud jus give genric syntax.


    abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Originally posted by stecal
    Thanks for the input. You can spoonfeed this guy or teach him how to fish. Don't you think the point of what I wrote was geared toward helping him learn some of this on his own? Isn't the use (or non-use) of the system tablespace one of the most fundamental design concepts, and what an easy thing to look up and learn for yourself.
    Hi Stecal

    sometimes spoon feeding is absolutely necessary..you just cant exepect that people who visit dbasupport.com are all oracle folks..at least not in the companies that i have been..many companies i have been expect that i be a sybase dba ,sql server dba ,oracle9ias dba unix Nt admin etc...now i dunno much about sql server had i been to a sql server forum and asked where is the sql server support then i require lotta of spoon feeding..You just cant make any conclusion about the people who visit this site..sometimes spoon feedin is a absolute necessary atleast initially..absolutely nuthin wrong..its like initally you need to feed me fish..and later i would learn how to fish...if i get fond of fish :-) and then if i get addicted i would even learn swimmin (expert ) and start fishin all by myself.

    regards
    Hrishy

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by hrishy
    Hi Stecal

    sometimes spoon feeding is absolutely necessary..you just cant exepect that people who visit dbasupport.com are all oracle folks..at least not in the companies that i have been..many companies i have been expect that i be a sybase dba ,sql server dba ,oracle9ias dba unix Nt admin etc...now i dunno much about sql server had i been to a sql server forum and asked where is the sql server support then i require lotta of spoon feeding..You just cant make any conclusion about the people who visit this site..sometimes spoon feedin is a absolute necessary atleast initially..absolutely nuthin wrong..its like initally you need to feed me fish..and later i would learn how to fish...if i get fond of fish :-) and then if i get addicted i would even learn swimmin (expert ) and start fishin all by myself.

    regards
    Hrishy
    Hrishy:

    Ultimate Answer!!!!!!!!


    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  9. #9
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by hrishy
    Hi Stecal

    sometimes spoon feeding is absolutely necessary..you just cant exepect that people who visit dbasupport.com are all oracle folks..at least not in the companies that i have been..many companies i have been expect that i be a sybase dba ,sql server dba ,oracle9ias dba unix Nt admin etc...now i dunno much about sql server had i been to a sql server forum and asked where is the sql server support then i require lotta of spoon feeding..You just cant make any conclusion about the people who visit this site..sometimes spoon feedin is a absolute necessary atleast initially..absolutely nuthin wrong..its like initally you need to feed me fish..and later i would learn how to fish...if i get fond of fish :-) and then if i get addicted i would even learn swimmin (expert ) and start fishin all by myself.

    regards
    Hrishy
    i would say spoon feeding to an extent is okay... but here the person is trying to create the user table in SYSTEM tablespace, that shows that the persons concept is not clear about what a SYSTEM tablespace is and of what importance is the SYSTEM tablespace for the database.

    Abhay you gave the person the solution but did you tell hem/her that he/she should not fool around with SYSTEM tablespace. No.

    So how do you think that your spoon feeding helped the person understand how wrong he/she was??

    He got the answer, he created the new tablespace, fine his job done now he would never bother to find out what was wrong in the first place.

    If you learn the hard way, you will never forget... But if you are spoon feeded all the time you will tend to forget, may be the next day itself
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    Originally posted by adewri
    i would say spoon feeding to an extent is okay... but here the person is trying to create the user table in SYSTEM tablespace, that shows that the persons concept is not clear about what a SYSTEM tablespace is and of what importance is the SYSTEM tablespace for the database.

    Abhay you gave the person the solution but did you tell hem/her that he/she should not fool around with SYSTEM tablespace. No.

    So how do you think that your spoon feeding helped the person understand how wrong he/she was??

    He got the answer, he created the new tablespace, fine his job done now he would never bother to find out what was wrong in the first place.

    If you learn the hard way, you will never forget... But if you are spoon feeded all the time you will tend to forget, may be the next day itself

    Hi Amar

    The person was trying to create a table in a system tablespace itself shows that he is a newbie to oracle or is not DBA aware..the person who suggested the answer could have said that you should not create a object in a system tablespace..abhay just provided a helpin hand..and stecal guided him in the right direction to the docs..now if the person is curious enough..he/she should take abhays spoon feedin combine it with her own curiosity and follow the path shown by stecal..

    "IT depends upon the individual oh how he or she takes it " I strongly beleive that spoon feedin is necessary..in the begining..and then it depends upon the user how he or she takes it..atleast thats the way i learnt..

    regards
    Hrishy

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