Re: 2 objects with same name

Alexandro Strack wrote:
>
> Hi all,
>
> I would like to know if somebody knows the solution to create 2
> objects with diferent characteristics but with the same name in the same
> instance of a database. We have used different tablespaces and it didn't
> work out.
>
> Ex.: create table test (field1 integer not null) tablespace TS1;
> create table test2 (field2 float not null) tablespace TS2;
>
> It didn't work.
>
> If you want send email to: astrack_at_nexocs.com.br
 I don'think you can have two objects with the same name.

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  ORACLE CONSULTANT
  WHITTMAN-HART CORPORATION
  CHICAGO.