problems importing table...

View: New views
3 Messages — Rating Filter:   Alert me  

problems importing table...

by EetieD :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I got some problems importing with an imp statement. I am trying to see a dump while importing one table, but unfortunately, I got the message: << Table "ADDRESS" not found in export file >>.  The 'blah.dmp' is not exported by 'user1'. What can be the cause of the error message?

imp show=y tables=(ADDRESS) userid='user1/user1@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521)))(CONNECT_DATA=(SID=sid1)(SERVER=DEDICATED)))' file=blah.dmp

Thanks for help!

Re: problems importing table...

by Francis Galiegue-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Tue, Oct 13, 2009 at 17:04, EetieD <khn@...> wrote:

>
> I got some problems importing with an imp statement. I am trying to see a
> dump while importing one table, but unfortunately, I got the message: <<
> Table "ADDRESS" not found in export file >>.  The 'blah.dmp' is not exported
> by 'user1'. What can be the cause of the error message?
>
> imp show=y tables=(ADDRESS)
> userid='user1/user1@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521)))(CONNECT_DATA=(SID=sid1)(SERVER=DEDICATED)))'
> file=blah.dmp
>

I think you meant to send that mail to another mailing list :p

--

Francis Galiegue
ONE2TEAM
Ingénieur système
Mob : +33 (0) 683 877 875
Tel : +33 (0) 178 945 552
fge@...
40 avenue Raymond Poincaré
75116 Paris

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@...
For additional commands, e-mail: user-help@...


Re: problems importing table...

by EetieD :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Oops..   thanks again!


EetieD wrote:
I got some problems importing with an imp statement. I am trying to see a dump while importing one table, but unfortunately, I got the message: << Table "ADDRESS" not found in export file >>.  The 'blah.dmp' is not exported by 'user1'. What can be the cause of the error message?

imp show=y tables=(ADDRESS) userid='user1/user1@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521)))(CONNECT_DATA=(SID=sid1)(SERVER=DEDICATED)))' file=blah.dmp

Thanks for help!