Import database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 27

Thread: Import database

  1. #1
    Join Date
    Jun 2001
    Posts
    31
    Hi all...

    Please urgent help is needed.

    Oracle 8.1.7
    HP 9000 UNIX 11.X platform

    I exported the database, and I'm trying to import the database back.
    The exported method I used is as follow:
    $ exp userid=system/manager full=y file=/dev/rmt/c0t3d0BEST

    The exporting of the database worked fine

    The problem is importing the database from the tape.
    The method used:
    $ imp userid=system/manager full=n file=/dev/rmt/c0t3d0BEST tables=job_classif_tab

    *** Just to ******** that the 'job_classif_tab' is under dmsdev schema ***

    The import did not work. This is the following errors:
    Import: Release 8.1.7.0.0 - Production on Wed Aug 8 13:55:42 2001

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


    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.07 via conventional path
    import done in US7ASCII character set and US7ASCII NCHAR character set
    IMP-00033: Warning: Table "JOB_CLASSIF_TAB" not found in export file
    Import terminated successfully with warnings.

    Could anyone help me out to solve this problem.

    Thanks,


    AED

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Qualify the table name with Schema name.

  3. #3
    Join Date
    Jun 2001
    Posts
    31
    This is the errors after the schema was qualified:

    $ imp system/systemdmsdev full=n file=/dev/rmt/c0t3d0BEST tables=dmsdev.job_classif_tab log=/u01/app/oracle/admin/dmsdev/exp/impdmsdev.log

    Import: Release 8.1.7.0.0 - Production on Wed Aug 8 16:01:09 2001

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


    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.07 via conventional path
    import done in US7ASCII character set and US7ASCII NCHAR character set
    IMP-00029: cannot qualify table name by owner (dmsdev.job_calssif_tab), use FROMUSER parameter
    IMP-00000: Import terminated unsuccessfully

    Could anyone suggest a solution..

    Thanks,
    AED

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    $ imp system/systemdmsdev full=n file=/dev/rmt/c0t3d0BEST fromuser=dmsdev touser=dmsdev tables=job_classif_tab log=/u01/app/oracle/admin/dmsdev/exp/impdmsdev.log
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Is this the same instance? It sounds like you are trying to use a different character set. Verify the NLS in the init.ora is the same. Is the target DB on the same version of Oracle as the export? this is another potential problem.

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131

    Lightbulb

    One other thing, if this is the exact syntax I think it is incorrect.

    $ imp userid=system/manager full=n file=/dev/rmt/c0t3d0BEST tables=job_classif_tab

    TABLES = (must be in brackets!)

    I could be wrong but I don't think so.
    MH

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Mr.Hanky
    TABLES = (must be in brackets!)

    I could be wrong but I don't think so.
    MH
    I don't think so. TABLES= does not have to be specified in parenthesis.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jan 2001
    Posts
    3,131
    That's it Hunter, it's on!


    http://technet.oracle.com/doc/server...ch02.htm#34966

    In all of the examples of both .PAR file and command line the TABLES = (is in parenthesis) I never tried it without.

    MH

  9. #9
    Join Date
    Jan 2001
    Posts
    3,131

    Talking

    Here is some late breaking news!!

    Additional Information: Some operating systems, such as UNIX, require that you use escape characters before special characters, such as a parenthesis, so that the character is not treated as a special character. On UNIX, use a backslash (\) as the escape character, as shown in the following example:

    TABLES=\(EMP,DEPT\)

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Mr.Hanky
    That's it Hunter, it's on!


    http://technet.oracle.com/doc/server...ch02.htm#34966

    In all of the examples of both .PAR file and command line the TABLES = (is in parenthesis) I never tried it without.

    MH
    Like I said, I don't think so.

    Read on...

    Code:
    C:\>sqlplus system
    
    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Aug 8 16:46:01 2001
    
    (c) Copyright 2000 Oracle Corporation.  All rights reserved.
    
    Enter password:
    
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    SQL> create table xyz (x number(5), y number(5), z number(5));
    
    Table created.
    
    SQL> create table abc (a number(5), b number(5), c number(5));
    
    Table created.
    
    SQL> exit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    C:\>exp system file=foo.bar tables=abc,xyz
    
    Export: Release 8.1.7.0.0 - Production on Wed Aug 8 16:48:04 2001
    
    (c) Copyright 2000 Oracle Corporation.  All rights reserved.
    
    Password:
    
    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
    
    About to export specified tables via Conventional Path ...
    . . exporting table                            ABC          0 rows exported
    . . exporting table                            XYZ          0 rows exported
    Export terminated successfully without warnings.
    
    C:\>sqlplus system
    
    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Aug 8 16:49:38 2001
    
    (c) Copyright 2000 Oracle Corporation.  All rights reserved.
    
    Enter password:
    
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    SQL> drop table xyz;
    
    Table dropped.
    
    SQL> drop table abc;
    
    Table dropped.
    
    SQL> exit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    C:\>imp system file=foo.bar tables=abc,xyz
    
    Import: Release 8.1.7.0.0 - Production on Wed Aug 8 16:50:36 2001
    
    (c) Copyright 2000 Oracle Corporation.  All rights reserved.
    
    Password:
    
    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    Export file created by EXPORT:V08.01.07 via conventional path
    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
    . importing SYSTEM's objects into SYSTEM
    . . importing table                          "ABC"          0 rows imported
    . . importing table                          "XYZ"          0 rows imported
    Import terminated successfully without warnings.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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