| error using clalter.plb [message #586325] |
Wed, 05 June 2013 05:12  |
 |
deepak416
Messages: 63
Registered: January 2013
Location: Pune
|
Member |
|
|
Hi ,
I am trying to change database characters using csalter.plb but i am facing below errors
bash-3.2$ $ORACLE_HOME/rdbms/admin/csalter.plb
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 2: /bin: is a directory
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 3: All: command not found
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 4: when: command not found
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 5: */: No such file or directory
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 6: insert: command not found
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 7: syntax error near unexpected token `u.user#,'
/opt/oracle/product/10g/rdbms/admin/csalter.plb: line 7: ` select distinct u.user#, u.name from sys.user$ u '
Please help and is there any way to better way to change the same
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: error using clalter.plb [message #586358 is a reply to message #586344] |
Wed, 05 June 2013 07:39  |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
As far as my experience with changing character set, that too when I was working abroad at client site, I can suggest only 1 thing, that changing the character set without checking all the NLS views and gv_$nls_parameters, it can result to data loss and unusual DB behavior.
Well, I have seen few DBAs suggesting this:-
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE CHARACTER SET WE8MSWIN1252;
-- if the above fails:
ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SHUTDOWN IMMEDIATE;
STARTUP;
SELECT *
FROM gv_$nls_parameters;
However, I personally restrict myself.
|
|
|
|
|
|
|
|
|
|
| Re: error using clalter.plb [message #586378 is a reply to message #586366] |
Wed, 05 June 2013 14:40 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 05 June 2013 20:55Better NEVER post such thing.
If you post it, it WILL be used, ANYWAY.
Well that's the reason we have test environments in software field(just kidding)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
