| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> re: utllockt under sqlplus
Patrice,
If you want to be able to run under sqlplus you can edit the utllockt.sql script:
search for the set charwidth line and comment it out and add a column line as below:
--set charwidth 17;
COLUMN waiting_session FORMAT A17
Note that the modified script won't work under svrmgrl - I haven't tried to get the script to work under both.
I don't have 9i so can't tell you what it looks like there.
HTH,
Bruce Reardon
-----Original Message-----
Sent: Friday, 4 January 2002 0:20
Another down side of the default database is... the GUI tool that the Oracle Universal Installer invokes doesn't support locally managed tablespaces, if I remember correctly.
So you will have to drop most of the tablespaces, then re-create them using DBA Studio if you want to use the GUI tools.
FYI I tried running utllockt.sql using sqlplus, I get SP2-0158: unknown SET option "charwidth" errors. sqlplus doesn't support that syntax, but svrmgrl does. I notified MetaLink, hopefully they corrected that in 9i.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 03 2002 - 17:40:31 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |