Oracle Database Discussions

Hi All,

We have oracle db 11.2 on aix.

We are creating Materialized view  from the system user to  scott.

For Ex:

we have the table scott.emp it has 3 columns name,age and dob.

sqlplus /nolog

conn system/Manager

CREATE MATERIALIZED VIEW scott.emp_mv

pctfree 0

TABLESPACE  Test

BUILD IMMEDIATE

REFRESH FORCE

ON DEMAND

AS

SELECT name FROM scott.emp;

i got the below error

ORA-01950: no privileges on table-space "Test"

But the same time,I can create a table ( create table scott.test1 ( n number ); ) from the system user.

The segment test1  created at the table-space Test.

Some confusion.....

Any suggestions

Thanks & Regards,