Re: database defragmentation :)

On Apr 3, 5:45 pm, "Joe" <joe1..._at_tlen.pl> wrote:
> I am making database backup by export all scheme. the size did not
> change after removing 70mb table (it is 60% of whole database). just
> wondering if ora does not work slower (well.. .the file is bigger than
> it should be (all data was from 70mb table was truncated))
>

OK, there is still quite a bit of ambiguity here. Please give:

The version of Oracle you are using (exactly, ie 10.2.0.3).

The operating system, version and platform you are using.

The exact exp command you are using (but don't show password).

The output of the directory command that shows the file size.

If you are using a unix type shell, note that you can see what's in the export file with the strings command. So you can search for the insert command for the data for your table like this: strings expdat.dmp |more
then while in more you can
/INSERT INTO \"YOUR_TABLE
to find the beginning of insert commands. Of course, if it has been truncated, you shouldn't have any. If this table is in multiple schemata it is possible you simply truncated the wrong one.

Also, don't top-post in this group. Either give your answer at the end of what you are replying to or interleave it.

jg

--
@home.com is bogus.
http://joshwolf.net/blog/