Why not simply use 2 users? Each user's schema can have table test1. With the proper grants you can work with both tables at the
same time, referencing them user1.test1 and user2.test2...
A. Fox
"Quoc Vu" <qvu_at_ipac.caltech.edu> wrote in message news:3D94DEFD.656F1357_at_ipac.caltech.edu...
> Hi all,
>
> Can a user work on 2 tablespace? Since I want a user can create a 2 tables with
> the same name in different tablespace. Is it possible to do that? Here what I
> did, but it didn't work.
>
> CREATE TABLESPACE test_01
> DATAFILE 'C:\learning\oracle\test_01.dbf' SIZE 1M REUSE
> EXTENT MANAGEMENT LOCAL;
>
> CREATE TABLESPACE test_02
> DATAFILE 'C:\learning\oracle\test_02.dbf' SIZE 1M REUSE
> EXTENT MANAGEMENT LOCAL;
>
> CREATE USER user1 IDENTIFIED BY user1
> DEFAULT TABLESPACE test_01
> QUOTA UNLIMITED ON test_01
> QUOTA UNLIMITED ON test_02;
>
> GRANT CREATE SESSION TO user1
> GRANT CREATE TABLE TO user1;
> GRANT ALTER TABLESPACE TO user1;
>
> connect as user/user
>
> CREATE TABLE test1
> (
> age NUMBER(3)
> );
>
> ALTER TABLESPACE test_01 OFFLINE;
>
> ALTER TABLESPACE test_02 ONLINE;
>
> CREATE TABLE test1
> (
> age NUMBER(3)
> );
>
> ORA-00955: name is already used by an existing object
>
> Thanks in advance,
> --Quoc
>
Received on Sun Sep 29 2002 - 08:05:18 CDT
