Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Space used by import/export
Suresh Bhat wrote:
> 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.
> >
> >
> >
If you are concerned with the space inside the database that the imported rows are taking up and those rows are the only ones in the table then you query DBA_EXTENTS for that information.
Allan Received on Sat Aug 01 1998 - 17:28:25 CDT