|
-
 Originally Posted by sonia_1985
Uff This Oracle will Kill Me One Day. I am not able to create table in ORACLE from last so many days...UFF.
I have executed the foll. statements in command Prompt . CREATE TABLE is giving me the ERROR - no privileges on tablespace 'SYSTEM'
Code:
SQL> SHOW USER
USER is "SONIA"
SQL>
SQL> SELECT username,privilege FROM USER_SYS_PRIVS;
USERNAME PRIVILEGE
------------------------------ ----------------------------------------
SONIA CREATE SESSION
SONIA CREATE TABLE
SQL> CREATE TABLE CUSTOMER(CustID Number(5) Primary Key, CustName Varchar(20));
CREATE TABLE CUSTOMER(CustID Number(5) Primary Key, CustName Varchar(20))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
You don't want to create user objects like a tale in SYSTEM tablespace.
Create a tablespace for your stuff, grant privs on it to SONIA, set that tablespace as the default tablespace for user SONIA then create your table :-)
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|