tablespaces & schemas

From: gaddoz <mynickname_at_gmail.com>
Date: Sun, 17 Apr 2005 20:03:12 GMT
Message-ID: <4iz8e.792134$b5.35210670@news3.tin.it>

Hi all,
I'm getting ORA-01950 error, when I try to create a table with sys user in the tablespace users.
The sys user have unlimited tablespace system privilege granted... so why sys can't use tablespace users?

And another problem... if I create a tables with userOne, why sys can't grant any privilege to UserTwo?
Only the owner of the table can grant privilege to other user? There is no way?
Can I change the owner of a table?

Excuse me.. but I'm getting crazy trying to administer tablespace and schemas...
Thank you!

Gaddoz Received on Sun Apr 17 2005 - 15:03:12 CDT