OraFAQ Forum: Server Utilities » File split and compress in Unix

Home » RDBMS Server » Server Utilities » File split and compress in Unix - how to import to W2K

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

File split and compress in Unix - how to import to W2K [message #73867]

Tue, 27 July 2004 05:55

KenS
Messages: 2
Registered: July 2004

Junior Member

The DBA's use the following command to export the production database.� How do�we import the resulting files into a Windows database?

�

nohup split -b2047m /tmp/${ORACLE_SID}_split_pipe ${export_dir}/${file_prefix}
&
nohup /usr/bin/compress </tmp/${ORACLE_SID}_compress_pipe >/tmp/${ORACLE_SID}_
split_pipe &
exp parfile=${etcpath}/exp_${ORACLE_SID}.par

Report message to a moderator

Re: File split and compress in Unix - how to import to W2K [message #73875 is a reply to message #73867]

Wed, 28 July 2004 03:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first, there similiar utilities available ( freeware ) in windows.
like winrar.exe and hjsplit.exe.
You can write wrapper script to do this.

>>>How do we import the resulting files into a Windows database?

first using similiar methods
first create pipes in background, join and uncompres the files and do the import through the pipe

If you want to use the file created in UNIX environment, then,
1. import from unix env (create tnsconnection to target db)
or
2. FTP the files to windows machine ( do FTP in BIN format) and do import.

Report message to a moderator

Re: File split and compress in Unix - how to import to W2K [message #73878 is a reply to message #73867]

Wed, 28 July 2004 04:53

KenS
Messages: 2
Registered: July 2004

Junior Member

Thanks for your response. I went the route of importing from a Unix environment. I couldn't do this originally because I only had access to Windows environments. Convinced Mgt to give Unix access and got it done. I will still look into the Exe's you mentioned. Thanks again!

Report message to a moderator

Previous Topic:	Migration from 7.3 to 8i (URGENT)
Next Topic:	Transferring data from microsoft word document to the db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 08:34:57 CST 2024