Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8i: Create database question

Re: Oracle8i: Create database question

From: <gzwzhang_at_my-deja.com>
Date: Fri, 08 Sep 2000 22:45:48 GMT
Message-ID: <8pbq6n$sgj$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US