empimpt
EMPIMPT(1) EMPIMPT(1)
NAME
empimpt - import an EMPRESS database tables.
SYNOPSIS
empimpt [-codeset CS] [-notable] [-nomodule] [-cdeghiklmprtvx] infile
database [[-tables] table ...] [-module module ...]
DESCRIPTION
Empimpt imports tables to an EMPRESS database (the database must
already exist -- a database may be created using empmkdb(1)). The data
to be imported must be in the format produced by empexpt(1). A list of
tables separated by spaces specifies tables to be imported (the table
names must correspond to the names given when the data was exported.)
If no tables are given all tables in the input file "infile" are
imported. If this file is "-" input is taken from standard input.
You should not attempt to explicitly import data to the data dictionary
tables. You may, however, import indices, comments and lock levels for
them. Imported comments and lock levels will override existing com-
ments and lock levels. Attempting to import an index that already
exists on a system table causes an error. The program will not create
the index and continue.
Imported tables are created in the database directory and are owned by
the user executing the program. To import tables you must have
"insert" privilege in the table "sys_tables". If any of the tables to
be imported exist, you must have "insert" privilege on them.
Pressing interrupt will not stop the program during critical phases.
Pressing the interrupt several times will usually stop the program.
-codeset CS treats the nls data in infile as stored in codeset CS in
order to translate it into the native codeset (e.g. Latin1,
EUC-JP). Avaliable codeset (CS) for translation could be,
for example, SJIS.
-notable Suppresses the import of all table definitions, comments,
lock levels, indices, range checks, referential checks and
data.
-nomodule Suppresses the import of all module definition.
-c Suppresses the import of comments.
-d Do not import actual data for tables, only the table informa-
tion is imported. Default is to import actual table data
from the export file into the database.
-e Import each table within a transaction ( one transaction per
table); if an error occurs, then the transaction is cancelled
and a recovery will be attempted to resume importing at the
next table/view. Default is not to import tables in transac-
tions and attempt to continue on errors. If the -e option is
not used, the following points apply:
Indices, comments, lock levels and range checks are not cre-
ated for the table. No message is printed.
If the table has any level of locking defined for it, the ta-
ble is locked during the insertion. If the table cannot be
locked ( as then it is in use), no insertions are attempted
for the table and a message is displayed. You may try to
insert the data for the table later.
If the insertion proceeds, records are inserted into the ta-
ble on the basis of attribute names. The presence of data
mapped to non-existent attributes causes the program to skip
to the next table. Additional attributes in the table are
set to null. If the first record contains data that is
incompatible with the data type of the attribute to which it
is mapped, the program will skip to the next table. Incom-
patible data in subsequent records causes the records to be
skipped. If inserting a record would cause the allowable
number of duplicate tuples to be exceeded, the record is
skipped. Care should be taken to avoid having some records
inserted while others are rejected.
-g Import grant privilege(s) information. Default is not to
import any grant privilege(s) information from the export
file.
-h Displays the name and number of records of each table in the
input stream or file. A view is indicated by the word
"VIEW". If this option is used, no data is imported. If
this option is given, the database need not be supplied.
-i Suppresses the import of indices.
-k Suppresses the import of referential constraints.
-l Suppresses the import of lock levels.
-m Suppresses the import of trigger definition.
-p Grants PUBLIC select and display privileges on all imported
tables.
-r Suppresses the import of range checks.
-t Do not create tables. Used when the tables already exists in
the destination database. Default is to create tables, and
if the table already exists, then import data only for the
table.
-v Causes execution in verbose mode, otherwise execution is
silent except for table names and error messages.
-x Do not perform checksum analysis on the imported table data.
A checksum analysis is always attempted on the primary header
regardless of this option. The default is to perform check-
sum analysis on the imported table data.
Note: if the export file does not contain checksum informa-
tion, then this option does nothing ( for backward compati-
bility ).
-table When this is specified, only tables provides in the table
list will be imported. If -notable option is also specified,
empimpt will print error message and exit.
-module When this is specified, only modules provided in the module
list will be imported. If -nomodule option is also speci-
fied, empimpt will print error message and exit.
FILES
EMPRESS database files
SEE ALSO
empexpt(1), empmkdb(1), empdbld(1)
Empress: Database Administrator's Guide
DIAGNOSTICS
Error diagnostics are printed if the database is not in EMPRESS format,
if the input is not in the format produced by empexpt(1), or if execu-
tion errors are detected.
HISTORY
Written by Empress Software Inc.. All material is copyrighted and
licensed. Use on non-licensed CPUs is prohibited.
Empress 8.62 Empress Software Inc. EMPIMPT(1)