[Oracle 9i] Is the script is the same as the interactive mode?

From: Karol <no_at_mail.com>
Date: Wed, 24 Jun 2009 10:49:16 +0200
Message-ID: <h1spb7$e1$1_at_inews.gazeta.pl>

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? Received on Wed Jun 24 2009 - 03:49:16 CDT