[Oracle 9i] Is the script is the same as the interactive mode?
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