| | Generate a script to create users from exp dump file
I usually run full export with ROWS=N on a development database before refreshing it from production, that way I can always re-create the users and schema objects from that exp dump file.
$ grep -i 'create role' [dump_file] > create_users.sql
$ grep -i 'create user' [dump_file] >> create_users.sql
$ grep -i '^grant' [dump_file] ... | | More...
10/26/06 | | | | |
|
| | Example exp parfile for Oracle full export
Here's an example of parfile for exporting the whole database without data (no rows):
FILE=DBNAME.dmp
COMPRESS=N
ROWS=N
LOG=DBNAMEexp.log
FULL=Y
Run from command line:
$ . oraenv
$ ORACLE_SID = [DBNAME] ?
$
$ exp parfile=DBNAMEexp.par
Export: Release 8.1.7.4.0 - Production on Wed May 10 10:20:48 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: / as sysdba
| |   
More...
05/10/06 | | | | |
|
| | Compress during export
Example of exporting via a named pipe:
$ /sbin/mknod /tmp/compress_pipe p
$ gzip -c < /tmp/compress_pipe >/opt/ora/export/SID/test_SID_via_pipe.dmp.gz &
$ exp [username]/[password]@[database] full=y file=/tmp/compress_pipe
| | More...
10/03/05 | | | | |
|
|
