Re: Is the script is the same as the interactive mode?

From: joel garry <joel-garry_at_home.com>
Date: Wed, 24 Jun 2009 09:49:35 -0700 (PDT)
Message-ID: <7942ed0b-b803-4d4f-878d-034b19b7b179_at_y10g2000prc.googlegroups.com>

On Jun 24, 1:49 am, "Karol" <n..._at_mail.com> wrote:
> Hi
> I need to create a script exporting the database in exactly the same way as
> in interactive
>
> Exp in interactive mode:
>
>   $ exp database_user/******
>    Enter array fetch buffer size: 4096 > 30720
>    Export file: expdat.dmp > database.dmp
>    (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 2
>    Export grants (yes/no): yes > n
>    Export table data (yes/no): yes > y
>    Compress extents (yes/no): yes > y
>
>    Export done in US7ASCII character set and AL16UTF16 NCHAR character set
>    server uses EE8ISO8859P2 character set (possible charset conversion)
>    Note: grants on tables/views/sequences/roles will not be exported
>
>    About to export specified users ...
>    User to be exported: (RETURN to quit) > database_user
>
> My script:
>
> exp userid=database_user/passwd parfile=backup.cfg
>
> The contents of the file backup.cfg
>
> BUFFER=30720
> FILE=/opt/backup/database.dmp
> FULL=n
> OWNER=database_user
> GRANTS=n
> COMPRESS=y
>
> Is the script is the same as the interactive mode?

In addition to what Mark said, I'd seriously consider using NLS settings that don't convert your database to us7ascii. That loses the top bit of the characters. It seems inevitable people underestimate what characters are in their database, especially when they say "this database will _never_ use any non-US characters." It's been a bad default back to Oracle7, at least.

Read the compress=y definition of export in the utilities manual very carefully.

jg

--
_at_home.com is bogus.
"That's not a Cougar, that's a sabre-toothed tiger."

Received on Wed Jun 24 2009 - 11:49:35 CDT