Re: Q: How to skip data from a certain column during import

Hi Kalle,

1. Make copy of the lob table without lob column (use copy command from sql*plus for example) with new name
2. Make export of the production database without original lob table.
3. Make import into development database.
4. Rename copy of lob table in development database into its original name

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

Kalle <kk.kk_at_kk.com> wrote in message news:<3F7924D1.84680266_at_kk.com>...
> Hi all,
>
> I have a special request.
>
> I need to take a consistent export from my production database and I
> need to copy this data to our dev environment. The export dump needs to
> be consistent, on that prod. environment there is lob column in a
> certain table with more than 50gig data.
>
> Now I need to import this to our dev environment WITHOUT this lob
> columnd, is there any way.
>
> Do you have any ideas!
>
> TIA
>
> Kalle
Received on Tue Sep 30 2003 - 10:24:50 CDT