Filter
Top Products
7-48 IBM Informix OnLine Database Server Administrator’s Guide
Syntax
If you are loading a table that contains blobs stored in a blobspace, a prompt
asks you if you want to move the blobs to another blobspace. If you respond
“yes,” the next prompt displays the blobspace name where the blobs were
stored when the tape was created. You are asked to enter the name of the
blobspace where you want the blobs stored. If the name you enter is valid, all
blob columns in the table are moved to the new blobspace during the load.
Otherwise, you are prompted again for a valid blobspace name.
When a new database is loaded, the user who runs tbload becomes the
owner. Ownership within the database (tables, views, and indexes) remains
the same as when the database was unloaded to tape with tbunload.
To load a table, you must have Resource privilege on the database. When a
new table is loaded, the user who runs tbload becomes the owner unless you
specify an owner in the table name. (To do so requires DBA privilege for the
database.)
Synonyms or access privileges defined for a table at the time it was unloaded
to tape are not carried over to the new table. To obtain a listing of defined
synonyms or access privileges, use the dbschema utility. (Refer to page 7-32.)
During the load operation, the new database or table is locked exclusively.
Loading proceeds as a single transaction, and the new database or table is
dropped in case of error or system failure.
Syntax
database is the name of the database. The database name cannot include
a database server name because tbload does not support a
client/server environment.
table name is the name of the table. The table name cannot include a
database server name because tbload does not support a
client/server environment.
Specify
Tape
Parameters
p. 7-49
Create
Options
p. 7-14
tbload database
table name