OraFAQ Forum: Server Utilities » oracle 9i,solaris 9

Home » RDBMS Server » Server Utilities » oracle 9i,solaris 9

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

oracle 9i,solaris 9 [message #295619]

Tue, 22 January 2008 22:28

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.

Report message to a moderator

Re: oracle 9i,solaris 9 [message #295642 is a reply to message #295619]

Tue, 22 January 2008 23:56

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.

Report message to a moderator

Re: oracle 9i,solaris 9 [message #295659 is a reply to message #295619]

Wed, 23 January 2008 00:47

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: oracle 9i,solaris 9 [message #295711 is a reply to message #295659]

Wed, 23 January 2008 02:49

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.

Report message to a moderator

Re: oracle 9i,solaris 9 [message #295716 is a reply to message #295711]

Wed, 23 January 2008 03:07

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: oracle 9i,solaris 9 [message #295984 is a reply to message #295716]

Thu, 24 January 2008 01:40

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 07:31:40 CDT 2024