[ Pobierz całość w formacie PDF ]
.Note that the number of parameterscannot exceed the maximum length of a command line on youroperating system." Enter the commandimpusername/password to begin an interactivesession, and let Import prompt you for the information it needs.TheImport 2-7 interactive method does not provide as much functionality as theparameter-driven method.It exists for backward compatibility.You can use a combination of the first and second options.That is, you can listparameters both in the parameters file and on the command line.In fact, youcan specify the same parameter in both places.The position of the PARFILEparameter and other parameters on the command line determines whatparameters override others.For example, assume the parameters fileparams.dat contains the parameter INDEXES=Y and Import is invokedwith the following line:imp system/manager PARFILE=params.dat INDEXES=NIn this case, becauseINDEXES=N occurs afterPARFILE=params.dat,INDEXES=N overrides the value of the INDEXES parameter in the PARFILE.You can specify the username and password in the parameter file, although, forsecurity reasons, this is not recommended.If you omit username/password, Import prompts you for it.See "Import Parameters" on page 2-14 for a description of each parameter.Getting Online HelpImport provides online help.Enterimp help=y on the command line to seea help printout like the one shown below.2-8 Oracle8 Server Utilities > imp help=yImport: Release 8.3.0 - Production on Tue May 27 6:23:16 1997(c) Copyright 1997 Oracle Corporation.All rights reserved.You can let Import prompt you for parameters by entering the IMPcommand followed by your username/password:Example: IMP SCOTT/TIGEROr, you can control how Import runs by entering the IMP command followedby various arguments.To specify parameters, you use keywords:Format: IMP KEYWORD=value or KEYWORD=(value1,value2,.,valueN)Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=Nor TABLES=(T1:P1,T1:P2), if T1 is partitioned tableKeyword Description (Default) Keyword Description (Default)-----------------------------------------------------------------------USERID username/password FULL import entire file (N)BUFFER size of data buffer FROMUSER list of owner usernamesFILE output file (EXPDAT.DMP) TOUSER list of usernamesSHOW just list file contents (N) TABLES list of table namesIGNORE ignore create errors (N) RECORDLENGTH length of IO recordGRANTS import grants (Y) INCTYPE incremental import typeINDEXES import indexes (Y) COMMIT commit array insert (N)ROWS import data rows (Y) PARFILE parameter filenameLOG log file of screen outputDESTROY overwrite tablespace data file (N)INDEXFILE write table/index info to specified fileCHARSET character set of export file (NLS_LANG)POINT_IN_TIME_RECOVER Tablespace Point-in-time Recovery (N)SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)ANALYZE execute ANALYZE statements in dump file (Y)FEEDBACK display progress every x rows(0)The Parameter FileThe parameter file allows you to specify Import parameters in a file wherethey can be easily modified or reused.Create a parameter file using any flatfile text editor.The command line option PARFILE= tells Import toread the parameters from the specified file rather than from the commandline.For example:imp parfile=filenameorimp username/password parfile=filenameThe syntax for parameter file specifications is one of the following:Import 2-9 KEYWORD=valueKEYWORD=(value)KEYWORD=(value1, value2,.)You can add comments to the parameter file by preceding them with thepound (#) sign.All characters to the right of the pound (#) sign are ignored.The following is an example of a partial parameter file listing:FULL=YFILE=DBA.DMPGRANTS=YINDEXES=Y # import all indexesSee "Import Parameters" on page 2-14 for a description of each parameter.Privileges Required to Use ImportThis section describes the privileges you need to use the Import utility and toimport objects into your own and others schemas.Access PrivilegesTo use Import, you need the CREATE SESSION privilege to log on to theOracle8 Server.This privilege belongs to the CONNECT role establishedduring database creation.You can do an import even if you did not create the export file.However, ifthe export file was created by someone using the EXP_FULL_DATABASErole, you can import that file only if you have the IMP_FULL_DATABASErole.2-10 Oracle8 Server Utilities Importing Objects into Your Own SchemaTable 2-1 lists the privileges required to import objects into your own schema.All of these privileges initially belong to the RESOURCE role.Table 2-1: Privileges Required to Import Objects into Your Own SchemaObject Privileges Privilege Typeclusters CREATE CLUSTER systemAnd: tablespace quota, orUNLIMITED TABLESPACE systemdatabase links CREATE DATABASE LINK systemCREATE SESSION on remote db systemdatabase triggers CREATE TRIGGER systemindexes CREATE INDEX systemAnd: tablespace quota, orUNLIMITED TABLESPACE systemintegrity constraints ALTER TABLE objectlibraries CREATE ANY LIBRARY systempackages CREATE PROCEDURE systemprivate synonyms CREATE SYNONYM systemsequences CREATE SEQUENCE systemsnapshots CREATE SNAPSHOT systemstored functions CREATE PROCEDURE systemstored procedures CREATE PROCEDURE systemtable data INSERT TABLE objecttable definitions CREATE TABLE system(including comments And: tablespace quota, orand audit options) UNLIMITED TABLESPACE systemviews CREATE VIEW systemAnd: SELECT on the base table, or objectSELECT ANY TABLE systemobject types CREATE TYPE systemforeign function CREATE LIBRARY systemlibrariesImporting GrantsTo import the privileges that a user has granted to others, the user initiatingthe import must either own the objects or have object privileges with theImport 2-11 WITH GRANT OPTION.Table 2-2 shows the required conditions for theauthorizations to be valid on the target system
[ Pobierz całość w formacie PDF ]