Very Computer

by **Serge Monte** » Tue, 21 Jul 1998 04:00:00

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.

by **Suresh Bha** » Tue, 21 Jul 1998 04:00:00

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 !!!

Quote:
> 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.

by **Allan Nelso** » Sun, 02 Aug 1998 04:00:00

> 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 !!!

> > 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

Very Computer

Space used by import/export

Space used by import/export

Space used by import/export

Space used by import/export