-
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
-
Qualify the table name with Schema name.
-
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
-
$ 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
-
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.
-
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
-
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
-
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
-
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\)
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|