Home » RDBMS Server » Server Administration » catlog.sql (10g,WIndowsXp)
catlog.sql [message #339776] Fri, 08 August 2008 07:57 Go to next message
niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai
Junior Member
Hi,
I am creating a database for the first time and while running the catlog.sql and catprod.sql..I got errors in the log file..Both the files must run without any error,if i am rite?
Error got while running catlog.sql:

drop table AUDIT_ACTIONS
*
ERROR at line 1:
ORA-00942: table or view does not exist
Can some one help?

Regards,
nivea
Re: catlog.sql [message #339788 is a reply to message #339776] Fri, 08 August 2008 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
while running the catlog.sql and catprod.sql..I got errors in the log file..

No doubt about this as the names are catalog.sql and catproc.sql

Errors on drops are "expected".

Regards
Michel
Re: catlog.sql [message #340013 is a reply to message #339788] Mon, 11 August 2008 00:24 Go to previous messageGo to next message
niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai
Junior Member
thx for your reply.
so it it ok ,that it can run with errors,or must i make sure,it doesnt.
Re: catlog.sql [message #340015 is a reply to message #340013] Mon, 11 August 2008 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Some errors are normal, others not, you have to check each one.

Regards
Michel
Re: catlog.sql [message #340062 is a reply to message #340015] Mon, 11 August 2008 05:33 Go to previous messageGo to next message
niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai
Junior Member
Hi michel,
How do we know wat errors are ok and wat are not?
In catlog.sql.
these were the other errors that i got.
SQL> CREATE ROLE exp_full_database;
CREATE ROLE exp_full_database
*
ERROR at line 1:
ORA-01921: role name 'EXP_FULL_DATABASE' conflicts with another user or role
name


SQL> CREATE ROLE imp_full_database;
CREATE ROLE imp_full_database
*
ERROR at line 1:
ORA-01921: role name 'IMP_FULL_DATABASE' conflicts with another user or role



Expect ORA-1921 for CREATE ROLE exp_full_database if this file is run
SQL> REM as part of the migration script and the role existed in the previous
SQL> REM release. Dropping will require DBA to regrant the role.

Wat do they mean??? Sad ..
Help!!!!
have also attached my catproc.sql log.and no idea wat is needed and wats not
Re: catlog.sql [message #340065 is a reply to message #340062] Mon, 11 August 2008 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It just mean that these roles can be created by several script and so the second one can't create it because it is already created => normal error.

As there are hundred "normal" errors, I think this topic will not end soon. Smile

Regards
Michel
Re: catlog.sql [message #340087 is a reply to message #340065] Mon, 11 August 2008 07:28 Go to previous messageGo to next message
niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai
Junior Member
Correct me if i am wrong.the database is created for the first time.There are no tables, roles etc...The catlog.sql only creates base tables or roles for the first.Then how is this error possible..

SQL> CREATE ROLE exp_full_database;
CREATE ROLE exp_full_database
*
ERROR at line 1:
ORA-01921: role name 'EXP_FULL_DATABASE' conflicts with another user or role
name.

Re: catlog.sql [message #340090 is a reply to message #340087] Mon, 11 August 2008 07:34 Go to previous message
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Because some scripts call some scripts that call the same scripts.

Regards
Michels
Previous Topic: check statistics
Next Topic: database creattion error
Goto Forum:
  


Current Time: Sat Dec 14 01:21:47 CST 2024