I have been reading about the datapump and came to know about
"compression"
parameter.
As per doc it will compress all the metadata before writing it out to

Consider the table myTable:
           first_name    varchar2(25),
           last_name    varchar2(25),
           regNum        number,

Let's face it: the code quality of Oracle 10 is worse then dirt.
There are many bugs, for various platforms, some of them extremely
critical (wrong results with ANSI joins or even with hash joins).
Oracle launched Oracle11 before fixing oracle 10.2 to an acceptable

Hmm, let's see. What is this NG about? Oracle? (Civil war?)
I really don't have much to say about Oracle. But let's talk about
Larry Page and Sergey Brin, the Google kids.
Do they read Google groups?

We have a query in one of our stored procedures, which I think may
have a logic bug in it given the dta it selects.
However, I do not understand this SIGN function and what its purpose
is here.......can someone help me and explain it to me??