ccmdb unpack

The ccmdb unpack command restores a database from a ccmdb pack file.

Synopsis

ccmdb unpack     packfile|archive_device|- [-o|-overwrite]
                 [-p|-space dbspace] [-s|-server servername]
                 -t|-to database_path [-url server_url]

Uses

Use the ccmdb unpack command to restore a database from a pack (.cpk) file created using ccmdb pack.

Note: You must have already set ORACLE_HOME and ORACLE_SID. Or use the -s option to use this command.

After unpacking a database (particularly from a packed production database), you might need to change some of the database properties, such as the paths to projects work areas. For important information about changing database properties, see work_area command.

To run this command, you must log on as the Oracle user who has write privileges for the appropriate tasks. For more information, see Setting up user privileges for UNIX on Oracle.

Options and arguments

-
Unpacks from standard input.
archive_device
Unpacks from an archive device.
-o|-overwrite
Causes the unpacked database to overwrite the specified database to database_path.
Use this option to disperse a large database over many drives under multiple file systems using symbolic links for the subdirectories of the database. You cannot overwrite a database if a database with the same name exists in Informix®. You can use the ccmdb drop command. Then, use the -overwrite option to write out the database.
-p|-space dbspace
Specifies the name of the dbspace. By default, the ccm dbspace is used.
Attention: Do not unpack a database to the temp dbspace.
packfile
Unpacks from a pack file.
-s|-server servername
Specifies the database server. This option requires that you set the ORACLE_SID, or specify the servername with the ORACLE_SID environment variable. If the -s servername argument is specified, it supersedes the ORACLE_SID environment variable.
-t|-to database_path
Specifies the path to the database to which you are unpacking.
-url server_url
When this option is specified, the new database is assigned to the specified server. Otherwise, it is assigned to the default CCM server running on the database server machine.

Example

Unpack the training database to a new database named /vol/orbit1/ccmdb/train72.

$ ccmdb unpack packfiles/training.cpk -t 
/vol/orbit1/ccmdb/train72

Enter user-name who has privileges of
CREATE USER, DROP USER, CREATE ANY INDEX, DROP ANY INDEX,
CREATE ANY SEQUENCE, CREATE ANY TABLE, INSERT ANY TABLE,
DROP ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE,
DELETE ANY TABLE, and GRANT ANY OBJECT PRIVILEGE:ccm_user
Enter password: 
Unpacking database /vol/orbit1/ccmdb/train72.
Creating Rational Synergy database /vol/orbit1/ccmdb/train72.
database create succeeded.
Extracting pack file /vol/orbit1/ccm71/packfiles/training.cpk.
Loading database.
loading Rational Synergy dump file version 7.2 platform UNIX ...
loading table attrib...
..............................3042 records.
loading table bind...
..289 records.
loading table bsite...
..213 records.
loading table compver...
...352 records.
loading table control...
0 records.
loading table relate...
.178 records.
loading table release...
10 records.
database unpacked successfully.ccmdb unpack base.cpk -to 
/vol/hydra/ccmdb/tstgonzo

Feedback