Re: Importing in Oracle8i

From: Karl R. <kreitsch_at_zdnetmail.com>
Date: Tue, 09 Nov 1999 01:50:35 -0800
Message-ID: <000b8d9b.427ff2a1@usw-ex0101-005.remarq.com>

Hello !

Use the import-Tool directly!
With NT ( imp in Oracle 8-Version ) you can see following paramters

C:\>imp80 help=yes

Import: Release 8.0.5.0.0 - Production on Tue Nov 9 10:55:50 1999

You can let Import prompt you for parameters by entering the IMP command followed by your username/password:

Example: IMP SCOTT/TIGER

Or, you can control how Import runs by entering the IMP command followed by 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=N
               or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

Keyword Description (Default) Keyword Description (Default)

USERID   username/password           FULL         import entire file (N)
BUFFER   size of data buffer         FROMUSER     list of owner
usernames
FILE     input file (EXPDAT.DMP)     TOUSER       list of usernames
SHOW     just list file contents (N) TABLES       list of table names
IGNORE   ignore create errors (N)    RECORDLENGTH length of IO record
GRANTS   import grants (Y)           INCTYPE      incremental import
type
INDEXES  import indexes (Y)          COMMIT       commit array insert
(N)
ROWS     import data rows (Y)        PARFILE      parameter filename
LOG      log file of screen output

DESTROY overwrite tablespace data file (N) INDEXFILE write table/index info to specified file CHARSET 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)

Import terminated successfully without warnings.

Importing full you need auser with this SystemPrivilege. system or sys

I do not know if a full import is possible because the databse version is different. If you like to import User-Objects only import the user-schema

Bye!

In article <0146ce5a.d247471f_at_usw-ex0110-075.remarq.com>, Fither Muhammed <fither_mNOfiSPAM_at_hotmail.com.invalid> wrote:
> Hey Gurus,
> I have an import problem.
> We are trying to import an ORACLE 8 database into ORACLE 8i
> Server. We tried it from ORACLE 8i's Enterprise Console,
> From there we connected to Schema Manager , Right clicked
> on the database node, From the pop up menu we selected Data
> Management and import.
> 1)The problem arises from there onwards, we cannot see any
> provision to specify Full Database import, Where can we
> specify it? Is there any utility like Data Manager in
> ORACLE 8.0.4 in ORACLE 8i for importing and exporting
> databases?
> 2) Continuing with Import Screen one Job can be scheduled,
> but the job cannot execute, Showing the error Message "VN-
> 2015 Authentication error" and stopped the execution. How
> can I overcome this error? How can I import data into
> ORACLE 8i server?
> Any suggestions, hints , experiences welcome.
> Regards
> fither_m_at_hotmail.com
> * Sent from AltaVista http://www.altavista.com Where you can also
> find related Web Pages, Images, Audios, Videos, News, and
> Shopping. Smart is Beautiful

Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Tue Nov 09 1999 - 03:50:35 CST