Home » SQL & PL/SQL » SQL & PL/SQL » I Have object problem on oracle 9i? (oracle 9i,widows xp)
I Have object problem on oracle 9i? [message #320394] Thu, 15 May 2008 00:00 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi

1st try to create the object using

Create Type Person As OBJECT (
   name varchar2(30),
   phone varchar2(20));

output

    Type created.


When i trying to create the instance of object im getting error.

CREATE TABLE person_table OF person;


error

ERROR at line 1: 
ORA-00955: name is already used by an existing object 



can i know why

wbr
kanish
Re: I Have object problem on oracle 9i? [message #320400 is a reply to message #320394] Thu, 15 May 2008 00:17 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Because you can't have two objects with the same name.
Oracle
ORA-00955 name is already used by an existing object


Cause: An attempt was made to create a database object (such as a table, view, cluster, index, or synonym) that already exists. A user's database objects must have distinct names.

Action: Enter a unique name for the database object or modify or drop the existing object so it can be reused.
Previous Topic: Exclude column in select
Next Topic: SQL query to return the value in columns
Goto Forum:
  


Current Time: Fri Dec 09 17:05:13 CST 2016

Total time taken to generate the page: 0.13963 seconds