OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Export

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

Export [message #63227]

Mon, 20 September 2004 09:36

salah
Messages: 2
Registered: February 2004

Junior Member

Oracle 9i on AIX 5.2
I try to copy a database from my Production server to the DEV server, both AIX 5.2.
Export was succesfuuly ended with .dmp 3.5 Gb.
When I try to copy this file (rcp, ftp, tar) to DEV server, It shows that 2 Gb limit was reached.
Are these options that allow me to acheave this import.
Thanx.
Salah

Report message to a moderator

Re: Export [message #63230 is a reply to message #63227]

Mon, 20 September 2004 16:36

andrew again
Messages: 2577
Registered: March 2000

Senior Member

I think exp can break files into smaller chunks. Try exp help=y.

You can also try compressing the .dmp file or simply import into the target database from the production server:

imp system/pass@dev ...

Report message to a moderator

Re: Export [message #63236 is a reply to message #63230]

Mon, 20 September 2004 22:57

Balaji
Messages: 102
Registered: October 2000

Senior Member

hi andrew ,

please observe caution when using exp in unix env. coz some unix file systems do not support a single file more than 2GB.

seek other alternatives like user wise exp or exp the db structure but no data and the data can be in other export dump .. try to mix n match to solve ur problem .

regards
balaji

Report message to a moderator

Re: Export [message #63242 is a reply to message #63236]

Tue, 21 September 2004 16:43

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

Senior Member
Account Moderator

>>
>>seek other alternatives like user wise exp or exp >>the db structure but no data and the data can be in >>other export dump .. try to mix n match to solve ur >>problem
what is the difference?
export with just DDL will be definatly negligible.
anyhow the data is going to be more than 2gb.
Andrew's solution to split the file into smaller files will help.

Report message to a moderator

Re: Export [message #63253 is a reply to message #63227]

Wed, 22 September 2004 12:12

croK
Messages: 170
Registered: April 2002

Senior Member

I beleive you can configure destination server so files can be grater.

www.consultoria-oracle.com
Remote DBA available for hire.

Report message to a moderator

Re: Export [message #63264 is a reply to message #63227]

Thu, 23 September 2004 04:21

Milind Deshpande
Messages: 93
Registered: May 2004

Member

Hi,

i believe the problem is with the O.S. not allowing the File size more than 2 GB. what you can do is you can use the Filesize parameter of Export utility which will split the file in the size you specified.

Oracle will ask for the filenames when the limit is reached.

Hope this helps.

All the best.

Milind.

Report message to a moderator

Previous Topic:	NLS_language, NLS_territory
Next Topic:	Server Rejected the Connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:29:03 CDT 2024