Importing .dmp to different schema.table

[jballum]

I have a .dmp with data from schema1.table1 (there is a create table statement as well). I need to import this .dmp file into an existing table called schema2.table2 (same fields as table data was exported from).

I have tried using IMP with all sorts of parameter variances but I always seem to get errors/warnings of some sort.

Is what I am trying to do possible and if so can anybody think of what I may be missing?

Example:

C:\oracle\ora9i\bin\imp system/manager fromuser=schema1 touser=schema2 tables=(table2) file=data.dmp ignore=Y indexes=N full=N grants=N commit=Y log=import

IMP-00033: Warning: Table "table2" not found in export file.

 

[SantaMufasa]

J,

To avoid recurrences of the trouble you have been experiencing, I would do the following:

1) Import into an empty schema (schema3, for example).
2) Grant SELECT on schema3.table2 to schema2.
3) Log into schema2 and issue the command:
insert into table2 select * from schema3.table2.

Does this seem reasonable?

Mufasa
(aka Dave of Sandy, Utah, USA @ 01:19 (08Jun04) UTC (aka "GMT" and "Zulu"), 18:19 (07Jun04) Mountain Time)

 

[HimanB]

J,
First of all check your export file to see if t=Table2 exists in the dump or not .to do so just run imp command with show=y.

If you are on Unix then try removing barckets before after table2 because 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\)

HTH
Himanshu

 

[jballum]

Thanks Mufasa. That was going to be my workaround if there was nothing to directly insert into the schema2.table2