-
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
-
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.
-
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"
-
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.
-
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.
-
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"
-
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
-
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"
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|