Home » SQL & PL/SQL » SQL & PL/SQL » How can I solve SP2-0024: Nothing to change. (Oracle 10g, Windows XP.)
How can I solve SP2-0024: Nothing to change. [message #326816] Thu, 12 June 2008 13:06 Go to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

Hi
I tried to create EXCEPTIONS table. utlexcpt.sql file is on C:\oracle\product\10.2.0\db_2\RDBMS\ADMIN directory and I issued
SQL> C:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utlexcpt.sql
but got
SP2-0024: Nothing to change.

Can you tell whats wrong & how to overcome it.


Thanks in advance
Suman
Re: How can I solve SP2-0024: Nothing to change. [message #326817 is a reply to message #326816] Thu, 12 June 2008 13:10 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
sumanbangladesh wrote on Thu, 12 June 2008 11:06
Hi
I tried to create EXCEPTIONS table. utlexcpt.sql file is on C:\oracle\product\10.2.0\db_2\RDBMS\ADMIN directory and I issued
SQL> C:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utlexcpt.sql
but got
SP2-0024: Nothing to change.

Can you tell whats wrong & how to overcome it.


Thanks in advance
Suman

SQL> @C:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\utlexcpt.sql

is how to properly invoke a SQL script file within SQL*Plus
Re: How can I solve SP2-0024: Nothing to change. [message #326818 is a reply to message #326816] Thu, 12 June 2008 13:16 Go to previous message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

Thanks anacedent, its working now


Regards,
suman
Previous Topic: locked rows
Next Topic: Suggestions and work around required urgently
Goto Forum:
  


Current Time: Fri Dec 09 11:50:32 CST 2016

Total time taken to generate the page: 0.11262 seconds