7-48 IBM Informix OnLine Database Server Administrator’s Guide
Syntax
Ifyou are loading a table that contains blobs stored in a blobspace, a prompt
asksyou 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
blobspacewhere 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 runstbload becomes the
owner.Ownership within the database (tables, views, and indexes) remains
the same as when the database was unloaded to tape withtbunload.
To load a table, you must have Resource privilege on the database. When a
newtable is loaded, the user who runs tbload becomes the owner unless you
specify an owner in the table name. (To do so requiresDBA privilege for the
database.)
Synonymsor 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
synonymsor 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 isthe 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