Re: tablespace

no you cant create 2 tables with the same name, whatever tablespace they may be on!!!

if you could do that and you did select * from test1 how would it know where to go!!!

"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 Fri Sep 27 2002 - 17:57:33 CDT