Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8i: Create database question
Using 'alter database backup controlfile to trace;' will create answer to your question in the udump directory.
In article <ZAdu5.103$Of7.12552_at_monger.newsread.com>,
"Van Messner" <vmessner_at_bestweb.net> wrote:
> With 8.1.5 and 8.1.6 on Solaris or NT the default character set is
> Western European 8 bit - which really makes sense these days. I
wouldn't go
> with ASCII7 unless you have to. The other two you can find in the
install
> documentation or by running the Gui database creation assistant and
looking
> at the defaults.
> By the way, if you are running under UNIX be sure to set the
environment
> variable NLS_LANG to eight bits. The default language for the
database is
> eight bits, but Oracle assumes the default NLS_LANG setting is seven
bits!
> So you can export from an 8 bit machine and import into an 8 bit
machine but
> still lose all of the second 128 character information (accent marks,
etc.).
>
> Van
>
> "Huy Vu" <huyv_at_usa.net> wrote in message
> news:968379962.351926_at_news.aei.ca...
> > Hi all,
> >
> > I forgot to put these options under 'CREATE DATABASE' clause:
> >
> > CREATE DATABASE "DB1"
> > Maxinstances 8
> > Maxlogfiles 32
> > Character set "US7ASCII"
> > National Character Set "US7ASCII"
> >
> > What are the values by default of the options above? What happen if
I
don't
> > put 'Character Set' and 'National Character Set' in creation of the
> > database?
> >
> > Thanks in advance for any advise.
> >
> > DH.
> >
> >
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 08 2000 - 17:45:48 CDT
![]() |
![]() |