DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: IMPORTING to a new Database -URGENT

  1. #1
    Join Date
    Dec 2000
    Posts
    10

    Unhappy

    Hi,
    I have a dmp file in one database. I like to import that to another database.. I couldn't find the syntax for doing this.. I'm new to system admin. Could anyone please help.

    Thanks..

    Regards,
    krishna

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Type in at the prompt

    $imp help=y

    gives the following options. More general options for full exp and imp are

    full=y
    rows=n
    commit=y
    ignore=y

    For the rest go thru documentation. Good Luck !

    ======================================================
    Import: Release 8.1.6.0.0 - Production on Wed Jan 10 23:30:36 2001

    (c) Copyright 1999 Oracle Corporation. All rights reserved.



    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 files (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 CONSTRAINTS import constraints (Y)
    DESTROY overwrite tablespace data file (N)
    INDEXFILE write table/index info to specified file
    SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)
    ANALYZE execute ANALYZE statements in dump file (Y)
    FEEDBACK display progress every x rows(0)
    TOID_NOVALIDATE skip validation of specified type ids
    FILESIZE maximum size of each dump file
    RECALCULATE_STATISTICS recalculate statistics (N)

    The following keywords only apply to transportable tablespaces
    TRANSPORT_TABLESPACE import transportable tablespace metadata (N)
    TABLESPACES tablespaces to be transported into database
    DATAFILES datafiles to be transported into database
    TTS_OWNERS users that own data in the transportable tablespace set

    Import terminated successfully without warnings.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    $imp userid/***** parfile=impdat.par

    WHERE impdat.par as follows:

    file=expdat.dmp
    buffer=102400
    log=impdat.log
    full=y
    ignore=y
    rows=y
    commit=y


    Note:Make sure

    you precreate all the tablespaces {as it as on fromdb} on {todb} to which you want to import.
    the counts of objects after the import are equal to {fromdb} objects.
    recompile all the {todb} objects.


    ***Find C-Ravi thread posted by C_Ravi,answered by me and others around dec last week for detailed steps.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width