Destination Options:
|--+--------------------------------------------+---------------|
+- -o--directory-----------------------------+
+- -t--device-- -b--blocksize-- -s--tapesize-+
'- -t--pathname------------------------------'
| Element | Purpose | Key Considerations |
|---|---|---|
| -b blocksize | Specifies, in kilobytes, the block size of the tape device | None. |
| -f pathname | Specifies the pathname where you want the schema file stored, if you are storing the data files on tape | Additional Information: The pathname can be a complete pathname or simply a filename. If only a filename is given, the file is stored in the current directory. |
| -o directory | Specifies the directory on disk in which dbexport creates
the database.exp directory.
This holds the data files and the schema file that dbexport creates for the database. |
Restrictions: The directory specified as directory name must already exist. |
| -s tapesize | Specifies, in kilobytes, the amount of data that you can store on the tape | Additional Information: To
write to the end of the tape, specify tapesize as
0.
Restrictions: If you do not specify 0, then the maximum tapesize is 2,097,151 kilobytes. |
| -t device | Specifies the pathname of the tape device where you want the text files and, possibly, the schema file stored | Restrictions: The -t option does not allow you to specify a remote tape device. |
When you write to disk, dbexport creates a subdirectory, database.exp, in the directory that the -o option specifies. The dbexport utility creates a file with the .unl extension for each table in the database. The schema file is written to the file database.sql. The .unl and .sql files are in the database.exp directory.
If you do not specify a destination for the data and schema files, the subdirectory database.exp is placed in the current working directory.
When you write the data files to tape, you can use the -f option to store the schema file to disk. You are not required to name the schema file database.sql. You can give it any name.
For non-SE database servers on UNIX or Linux, the command is as follows:
dbexport //finland/reports
The following command exports the database stores_demo to tape with a block size of 16 kilobytes and a tape capacity of 24,000 kilobytes. The schema file is written to /tmp/stores_demo.imp.
dbexport -t /dev/rmt0 -b 16 -s 24000 -f /tmp/stores_demo.imp stores_demo
The following command exports the same stores_demo database to the directory named /work/exports/stores_demo.exp. The resulting schema file is /work/exports/stores_demo.exp/stores_demo.sql.
dbexport -o /work/exports stores_demo
For Windows, the following command exports the database stores_demo to tape with a block size of 16 kilobytes and a tape capacity of 24,000 kilobytes. The schema file is written to C:\temp\stores_demo.imp.
dbexport -t \\.\TAPE2 -b 16 -s 24000 -f C:\temp\stores_demo.imp stores_demo
The following command exports the same stores_demo database to the directory named D:\work\exports\stores_demo.exp. The resulting schema file is D:\work\exports\stores_demo.exp\stores_demo.sql.
dbexport -o D:\work\exports stores_demo