Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace

Re: tablespace

From: A. Fox <afox.nospam_at_rogers.com>
Date: Sun, 29 Sep 2002 13:05:18 GMT
Message-ID: <iUCl9.137472$8b1.126333@news01.bloor.is.net.cable.rogers.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US