Import database

[appash]

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,

[tamilselvan]

Qualify the table name with Schema name.

[appash]

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,

[marist89]

$ 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

[Mr.Hanky]

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.

[Mr.Hanky]

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

[marist89]

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.

[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

[Mr.Hanky]

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\)

[marist89]

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...

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.