ERROR:ORA-00955 while creating Packages!

Hi all!

Wishing you a very happy new Year 2002!

Query:

1.I tried to create a Package named xyz but got the error:

ERROR:ORA-00955:name is already used by an existing object!

sql>

What could have gone wrong!

2.Could you please provide me scripts for automatically taking Hot and cold Backups with OS:WIN NT,WIN 98 with Oracle v8i 8.1.6.0.0

Take care.

Amit.

You can do
select object_name, object_type from user_objects where object_name like %XYZ% ;

You would definitely be having an object named xyz. Either delete it or name your package differently.

Quote:

---

1.I tried to create a Package named xyz but got the error:

ERROR:ORA-00955:name is already used by an existing object!

sql>

What could have gone wrong!

---

Well, you or someone with your username has already created an object called xyz.