Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Is it possible to have 2 tables with the same name in an Orable database?

811242Mar 2 2011 — edited Mar 13 2011

Hello,

I'm a complete Oracle newbie so please excuse my question if it's stupid.

I was trying to create 2 tables with the same name using different tablespaces but it does not seem to work. Like this (second time just change the name of the tablespace):

CREATE TABLE test_tbl (
  id INTEGER,
  status VARCHAR2(10),
  last_modified DATE DEFAULT SYSDATE
) 
TABLESPACE tblspc1

Is it in general in Oracle possible to acquire this goal?

Thanks a lot!

P.S. I have already created the needed tablespaces

CREATE TABLESPACE tblspc1 DATAFILE 'tblspc1.dbf' SIZE 10M

Edited by: 808239 on 02-Mar-2011 02:18

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2011

Added on Mar 2 2011

5 comments

2,651 views