We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

IMP-00037: Character set marker unknown using unix pipe

LindaC
LindaC asked
on
Medium Priority
4,506 Views
Last Modified: 2013-12-27
I have made a full Oracle export using a pipe named exp_pipe.dmp.
When I try today to import it is giving me the following error:

IMP-00037: Character set marker unknown
IMP-00000: Import terminated unsuccessfully
10558 Broken Pipe


The import that I'am doing is with the script named imp_ctit.sh with the following lines:

PATH=.:/usr/bin::/oracle_home/app/oracle/product/9.2.0/bin:/usr/ccs/bin:/usr/bin
:/etc:/usr/openwin/bin:/usr/local/bin://oracle_home/app/oracle/product/9.2.0/jdb
c/lib:/usr/sbin
export PATH
ORACLE_HOME=/oracle_home/app/oracle/product/9.2.0
export ORACLE_HOME
ORACLE_SID=TSTCTI
export ORACLE_SID
uncompress < /oravl03/TSTCT2.dmp.Z > /oravl03/imp_pipe.dmp & imp file=/oravl03/i
mp_pipe.dmp userid=backup_user/backup_user fromuser=CTITAPP1,CTITAPP2,CTITAPP3,C
TITDLR1,CTITDLR2,CTITDLR3 touser=CTITAPP1,CTITAPP2,CTITAPP3,CTITDLR1,CTITDLR2,CT
ITDLR3 statistics=none ignore=Y

Any clues how to make it work ?
Comment
Watch Question

system administrator
Top Expert 2007
Commented:
single & will put previous command to background, try &&:

uncompress < /oravl03/TSTCT2.dmp.Z > /oravl03/imp_pipe.dmp && imp file=/oravl03/i
mp_pipe.dmp userid=backup_user/backup_user fromuser=CTITAPP1,CTITAPP2,CTITAPP3,C
TITDLR1,CTITDLR2,CTITDLR3 touser=CTITAPP1,CTITAPP2,CTITAPP3,CTITDLR1,CTITDLR2,CT
ITDLR3 statistics=none ignore=Y

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Artysystem administrator
Top Expert 2007

Commented:
also try the 'fileless' way running import:

uncompress -c /oravl03/TSTCT2.dmp.Z | imp file=- userid=backup_user/backup_user fromuser=CTITAPP1,CTITAPP2,CTITAPP3,C
TITDLR1,CTITDLR2,CTITDLR3 touser=CTITAPP1,CTITAPP2,CTITAPP3,CTITDLR1,CTITDLR2,CT
ITDLR3 statistics=none ignore=Y

need to test
XoF

Commented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: Nopius

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

-XoF-
EE Cleanup Volunteer
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.