Oracle Database Discussions

Hi.

I´m trying to create a table in a different tablespace when i´m logged as sys but then i´ve ORA-01950: no privileges on tablespace TBS1

I´ve executed

ALTER USER SYS QUOTA 50M ON TBS1;

GRANT UNLIMITED TABLESPACE TO SYS;

GRANT CREATE ANY TABLE TO SYS;

But it don´t work.

The script of the table is:

CREATE TABLE TBS1.table
(
ROW1 CHAR(8 BYTE),
ROW2 CHAR(10 BYTE),
ROW3 CHAR(25 BYTE),
ROW4 CHAR(25 BYTE),
ROW5 CHAR(25 BYTE),
ROW6 CHAR(10 BYTE),
ROW7 NUMBER,
ROW8 CHAR(1 BYTE),
ROW9 CHAR(1 BYTE),
ROW10 CHAR(20 BYTE)
)
TABLESPACE OMI
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;

any suggestion???


thanks