Sorry guys, was my mistake... I found one file missing in global
tablespace. Copying it there fixed the problem.
Thanks everyone!
On Mon, 2007-12-24 at 14:07 -0800, Richard Broersma Jr wrote:
> --- On Mon, 12/24/07, Alex Vinogradovs <AVinogradovs@xxxxxxxxxxxxxxxx> wrote:
>
> > P.S. datafiles are 85GB in size, I couldn't really dump
> > and restore...
>
> Don't for get the steps of compressing and uncompressing between dump and restore.;) If the file is still too big, you can always use tar to spit the file up to make the transition a bit more manageable.
>
> Regards,
> Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
