tablespace

From: Quoc Vu <qvu_at_ipac.caltech.edu>
Date: Fri, 27 Sep 2002 15:43:09 -0700
Message-ID: <3D94DEFD.656F1357@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:43:09 CDT