| MOUNT DATABASE [message #51964] |
Mon, 24 June 2002 06:06  |
ron
Messages: 50
Registered: July 1999
|
Member |
|
|
I need to mount the database in EXCLUSIVE...to changet the character set...
how do i do it ?...also how do i come out of it once iam done...
any help is appreciated....
thanks
|
|
|
|
| Re: MOUNT DATABASE [message #51970 is a reply to message #51964] |
Mon, 24 June 2002 08:31  |
ecpdba
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
ALTER DATABASE db1 CHARACTER SET UTF8;
ALTER DATABASE db1 NATIONAL CHARACTER SET UTF8;
Or whatever you need.
I am not sure that you need to be in restricted access mode, but here is the syntax.
ALTER SYSTEM
ENABLE RESTRICTED SESSION;
ALTER SYSTEM DISABLE RESTRICTED SESSION:
Tested this on 8.1.7 / Win 2K.
Hth.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
