Re: Backing up Data in Oracle 9.2

Hi,

> There are a number of secondary questions you need to ask & answer before
a
> satsifactory response can be provided. You might be looking for 'export',
or
> 'recovery manager' or simply a normal copy of >>all<< relevant files when
the
> database is shut down.
>
> I advise you read some documents first so you get an understandng of your
> environment and you can pose the specific question you need answered.
The
> documents are located at http://docs.oracle.com - go the the version of
your
> database, 'view' the documents and 'list books' ... the books you need to
read
> are: 1) Concepts Manual and 2) Administrator's Guide (especially the
backup
> and recovery sections). Then you might want to read the Recovery Manager
> document(s) either to understand how to use RMAN or for additional insight
on
> the solution areas. (Export is covered in the Utilities User Guide - same
> place).
>
>

Thanks for the replies...I've read some stuff, and think that I need a full export. The only question arises in the following passage:

"It is a prerequisite that oraenv or coraenv (if you are working in a c-shell) was executed before you export, import data. Consider, if you stored data in the database by using an national language support (NLS) other than AMERICAN you have to change your environment before import, export.
Example for a german environment:
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
export NLS_LANG"

Now where to change that? In the command line? It could be that I've got german language support...

Thanks,

                Can