IBM 000-8697 Instrukcja Użytkownika Pobierz pdf (Strona 488)

100

101

7-10 IBM Informix OnLine Database Server Administrator’s Guide

dbimport: Create a Database

Thestatements in theASCII schemaﬁlethat createtables, views, andindexes

and grant privileges do so using the name of the person who originally

created the database. In this way, the original owner retains DBA privileges

for the database and is the owner of all the tables, indexes, and views. In

addition, whoever executes the dbimport command alsohas DBA privileges

for the database.

dbimport: Create a Database

The dbimport utility creates a database and loads it with data from input

ASCII ﬁlesgeneratedbydbexport.TheASCII ﬁlesconsistofaschemaﬁlethat

isused to re-createthedatabaseand data ﬁlesthatcontainthe database data.

The dbimport utility can read the ASCII ﬁles from the following three

location options:

■ All input ﬁles are located on disk.

■ All input ﬁles are located on tape.

■ The schema ﬁle is located on disk, and the data ﬁles are located on

tape.

Refer to page 7-9 for more details about the contents and use of the schema

ﬁle generated by dbexport.

The dbimport utility supports the following create options for the new

database:

■ Create an ANSI-compliant database (includes unbuffered logging).

■ Start transaction logging for a database (unbuffered or buffered

logging).

■ Specify the dbspace where the database will reside.

The user who runs dbimport is granted DBA privilege on the newly created

database.

The dbimport process locks each table as it is being loaded and unlocks the

table when the loading is completed.

1 2 ... 483 484 485 486 487 488 489 490 491 492 493 ... 701 702

Komentarze do niniejszej Instrukcji

Brak uwag

IBM 000-8697 Instrukcja Użytkownika Strona 488

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie bazy danych IBM 000-8697