SayYou_SayMe
asked on
what can do in MY schema in oracle
Hi Guys
i just want to know what can i do in my schema in oracle?
can i create any table , for example?
create table test(ID number)
it shows me :ORA-01950:no privileges on tablespace 'USERS'
i just want to know what can i do in my schema in oracle?
can i create any table , for example?
create table test(ID number)
it shows me :ORA-01950:no privileges on tablespace 'USERS'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can I create a table under my schema
like this ? abc is another schema in the same instance(database)
create table TEST as select * from abc.product where 1=2
like this ? abc is another schema in the same instance(database)
create table TEST as select * from abc.product where 1=2
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
should DBA perform this Alter?