Re: Space used by import/export

Try

imp userid=/ fromuser=ops$oneuser show=y file = export_filename log=logfile_name

This gives you a script for all tables, indexes, primary keys, constraints etc. used by the ops$oneuser.

Of course the export file must have been exported with compress=y option.

Also play with indexfile=y rather than show=y, which will give you script for only tables and indexes.

None of the objects will be created nor data imported.

Good luck !!!  

suresh.bhat_at_mitchell-energy.com

Serge Montet <serge.montet_at_wanadoo.com> wrote in article <6ovose$dc4_at_work.wanadoo.com>...
>
> Hello,
>
> I'd like to know how could I evaluate the space taken by imported
data
> of only one user. I think I have to use the view DBA_FREE_SPACE for that
> owner and sum the bytes column; but I'm not sure.
>
> Can you help me ?
>
> Thank you.
>
>
>
Received on Mon Jul 20 1998 - 14:10:11 CDT