Home » RDBMS Server » Server Utilities » exp and imp (10g)
exp and imp [message #531841] Fri, 18 November 2011 00:30 Go to next message
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.


Re: exp and imp [message #531855 is a reply to message #531841] Fri, 18 November 2011 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 66861
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: exp and imp [message #531859 is a reply to message #531855] Fri, 18 November 2011 02:00 Go to previous messageGo to next message
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
Re: exp and imp [message #531860 is a reply to message #531859] Fri, 18 November 2011 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 66861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your specific case and shell (we don't know on which OS you run).

Regards
Michel
Re: exp and imp [message #531866 is a reply to message #531860] Fri, 18 November 2011 02:22 Go to previous messageGo to next message
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]


Re: exp and imp [message #531868 is a reply to message #531866] Fri, 18 November 2011 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 66861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the statement at line 12?

Regards
Michel
Re: exp and imp [message #531869 is a reply to message #531866] Fri, 18 November 2011 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 66861
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: exp and imp [message #531901 is a reply to message #531866] Fri, 18 November 2011 06:16 Go to previous message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi Michel,

Thanks for provinding the input.
Issue is resolved. Smile

Thanks once again........
Previous Topic: Oracle IMPDP
Next Topic: Oracle 9i
Goto Forum:
  


Current Time: Tue Feb 25 04:44:05 CST 2020