Home » RDBMS Server » Server Utilities » oracle 9i,solaris 9
oracle 9i,solaris 9 [message #295619] Tue, 22 January 2008 22:28 Go to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Hi all,

i have to take export of a large schema which contains 64GB data.
The problem is i have 30GB on one mount point say /u01 and 10 GB on another mount point.
I can use FILESIZE parameter to make multiple dump files.
But is there any other way ?
i have to set crontab to make backup on alternate days.Also suggest me the fast method.
Re: oracle 9i,solaris 9 [message #295642 is a reply to message #295619] Tue, 22 January 2008 23:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You can copy tablespace specific data by transport_tablespaces feature which is fast with restrictions.
Re: oracle 9i,solaris 9 [message #295659 is a reply to message #295619] Wed, 23 January 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can compress through a pipe at the same time you export then you don't need so much space.
Something like:
mknod exp.pipe p
gzip < exp.pipe > scott.exp.gz &
exp userid=scott/tiger file=exp.pipe

Regards
Michel

Re: oracle 9i,solaris 9 [message #295711 is a reply to message #295659] Wed, 23 January 2008 02:49 Go to previous messageGo to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Thanx Michel,

But i need to create multiple dump files of 2gb.How can i use filesize parameter using pipe.
Re: oracle 9i,solaris 9 [message #295716 is a reply to message #295711] Wed, 23 January 2008 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No but you can split the output file.
Something like (beware! not tested):
mknod exp.pipe p
(gzip < exp.pipe | split -b 2048m - scott.dmp.gz.) &
exp userid=scott/tiger file=exp.pipe

Regards
Michel
Re: oracle 9i,solaris 9 [message #295984 is a reply to message #295716] Thu, 24 January 2008 01:40 Go to previous message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Thanx Michel,
it works.

[Updated on: Thu, 24 January 2008 03:13]

Report message to a moderator

Previous Topic: Problem during loading data to Oracle XE table
Next Topic: Export by date
Goto Forum:
  


Current Time: Fri Dec 09 15:43:26 CST 2016

Total time taken to generate the page: 0.17663 seconds