OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » exp and imp (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp and imp [message #531841]

Fri, 18 November 2011 00:30

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

I have near 114 export.dmp.z* export backup.

I am trying to import it on newly created database using imp.

But i am not getting how can i select all export.dmp.z* files using imp.

Its easy in impdp, but i have exported backup.

Any clue on it.

Report message to a moderator

Re: exp and imp [message #531855 is a reply to message #531841]

Fri, 18 November 2011 01:37

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But i am not getting how can i select all export.dmp.z* files using imp.

You can't.
Use a shell script.

Regards
Michel

Report message to a moderator

Re: exp and imp [message #531859 is a reply to message #531855]

Fri, 18 November 2011 02:00

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi Michel,

Thanks for providing info.
But any eg will be apprecialbe on it.....

Thanks in Advance

Report message to a moderator

Re: exp and imp [message #531860 is a reply to message #531859]

Fri, 18 November 2011 02:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends on your specific case and shell (we don't know on which OS you run).

Regards
Michel

Report message to a moderator

Re: exp and imp [message #531866 is a reply to message #531860]

Fri, 18 November 2011 02:22

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi Michel,

ls -ltr GSCSDEP1.EXPORT.102811.dmp.*
GSCSDEP1.EXPORT.102811.dmp.Zaa GSCSDEP1.EXPORT.102811.dmp.Zbd GSCSDEP1.EXPORT.102811.dmp.Zcg GSCSDEP1.EXPORT.102811.dmp.Zdj
GSCSDEP1.EXPORT.102811.dmp.Zab GSCSDEP1.EXPORT.102811.dmp.Zbe GSCSDEP1.EXPORT.102811.dmp.Zch GSCSDEP1.EXPORT.102811.dmp.Zdk

These are the dumpfiles name.

I am trying using mknod, but not useful.
mknod imp_pipe p
uncompress < /oradata/GSCSDEP1.EXPORT.102811.dmp.Z* > /tmp/rkpipe_GSCSDED1 &
imp / file=/tmp/rkpipe_GSCSDED1 FULL=Y buffer=204857600 ignore=y rows=y indexes=y log=/oraapp/imp.log statistics=none RESUMABLE=Y RESUMABLE_TIMEOUT=7200

Below iare the erros:
./GSCSDED1_imp_girish.ksh: line 12: /oradata/GSCSDEP1.EXPORT.102811.dmp.Z*: cannot open [No such file or directory]

Report message to a moderator

Re: exp and imp [message #531868 is a reply to message #531866]

Fri, 18 November 2011 02:28

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is the statement at line 12?

Regards
Michel

Report message to a moderator

Re: exp and imp [message #531869 is a reply to message #531866]

Fri, 18 November 2011 02:30

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure your current directory is are in /oradata?

And also:
mknod imp_pipe p
file=/tmp/rkpipe_GSCSDED1

Shouldn't file be /oradata/imp_pipe?

Regards
Michel

Report message to a moderator

Re: exp and imp [message #531901 is a reply to message #531866]

Fri, 18 November 2011 06:16

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi Michel,

Thanks for provinding the input.
Issue is resolved. Smile

Thanks once again........

Report message to a moderator

Previous Topic:	Oracle IMPDP
Next Topic:	Oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 18:18:04 CST 2025