Home » RDBMS Server » Server Utilities » Data Compression in Oracle 10g
Data Compression in Oracle 10g [message #479502] Mon, 18 October 2010 02:02 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
Hi All,

Is there any way to compress data while export in ORACLE 10g or if there is any other way I can reduce the space consumed by the datafiles.

Thanks
Deepak

[Updated on: Mon, 18 October 2010 02:10]

Report message to a moderator

Re: Oracle 10g [message #479508 is a reply to message #479502] Mon, 18 October 2010 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In the same way than in the previous versions.

Quote:
I can reduce the space consumed by the datafiles.

Which datafiles? dump files you mean?

Regards
Michel

Report message to a moderator

Re: Oracle 10g [message #479513 is a reply to message #479508] Mon, 18 October 2010 02:25 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member
Yes Sir, I missed that keyword.

Thanks
Deepak

Report message to a moderator

Re: Data Compression in Oracle 10g [message #479809 is a reply to message #479502] Tue, 19 October 2010 08:23 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
dsharma wrote on Mon, 18 October 2010 03:02
Hi All,

Is there any way to compress data while export in ORACLE 10g or if there is any other way I can reduce the space consumed by the datafiles.

Thanks
Deepak

Use rman and try the "BACKUP AS COMPRESSED BACKUPSET" option.

[Updated on: Tue, 19 October 2010 08:28] by Moderator

Report message to a moderator

Re: Data Compression in Oracle 10g [message #479810 is a reply to message #479809] Tue, 19 October 2010 08:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This an export question not a backup one.
How do you do it to export one of my table with RMAN?

Regards
Michel

Report message to a moderator

Re: Data Compression in Oracle 10g [message #480003 is a reply to message #479810] Wed, 20 October 2010 12:28 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
How do you know if the OP is doing (or not) a FULL export?
If this is the case (full export), rman is the best option.

[Updated on: Wed, 20 October 2010 12:44] by Moderator

Report message to a moderator

Re: Data Compression in Oracle 10g [message #480013 is a reply to message #480003] Wed, 20 October 2010 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The question is about export, you can talk about RMAN or football but this has nothing to do with the question.
If you want to extend the question, PM OP, don't do it in forum.

Regards
Michel

[Updated on: Wed, 20 October 2010 12:46]

Report message to a moderator

Re: Data Compression in Oracle 10g [message #480337 is a reply to message #480013] Fri, 22 October 2010 08:46 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Michel Cadot wrote on Wed, 20 October 2010 13:45

If you want to extend the question, PM OP, don't do it in forum.

Why not?
I beleive in providing the OP's (and other readers of the post) with options they may have not considered.

[Updated on: Fri, 22 October 2010 09:41] by Moderator

Report message to a moderator

Re: Data Compression in Oracle 10g [message #480342 is a reply to message #480337] Fri, 22 October 2010 09:00 Go to previous messageGo to next message
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
Senior Member
There's an example of how to export to a pipe which is then read by a compression program here,

http://www.orafaq.com/wiki/Import_Export_FAQ

Report message to a moderator

Re: Data Compression in Oracle 10g [message #480351 is a reply to message #480337] Fri, 22 October 2010 09:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Why not?
I beleive in providing the OP's (and other readers of the post) with options they may have not considered.

It does not matter, it is an EXPORT question which has nothing to do with backup and RMAN.
Then you mixed unrelated points and the topic becomes a mess.
Mad Razz Mad Razz

Regards
Michel

Report message to a moderator

Re: Data Compression in Oracle 10g [message #480404 is a reply to message #480351] Sat, 23 October 2010 13:53 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, if I answered the question, I'd say "do the export and ZIP the .DMP file" /forum/fa/3314/0/

Report message to a moderator

Previous Topic: imp issue (2 threads merged by bb)
Next Topic: Need way to Wrap my PL/SQL code
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 23:49:31 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.