Re: Reorganising a Tablespace

Mike,

If the objects owned by the four owners exist in this tablespace and only this tablespace, you could use the OWNERS=<lst> option. This will export the objects owned by the four specified users. If they have objects in other tablespaces, the situation gets a bit more complicated. Hopefully, this will address your needs.

How can you tell where an owner's objects reside? Try:

select tablespace_name, segment_type, count(*) from dba_segments
where owner = 'SCOTT'
group by tablespace_name, segment_type

-or-

select owner, tablespace_name, segment_type, count(*) from dba_segments
where owner in ('SCOTT', 'DEMO', 'PO7')
group by owner, tablespace_name, segment_type

Matt...

Matthew F. Reagan <mreagan_at_fast.net>
Manager, Technical Development
Centocor, Inc.

***The opinions expressed here are my personal opinions and have nothing to do with my company. Of course, my opinions usually don't change when I'm at the office...***

Mike R <mriney_at_xdircon.co.uk> wrote in article <5g705e$6g$1_at_newsserver.dircon.co.uk>...
> I need to combine 4 files which comprise a tablespace into 1 file. To
> do this I have to export the data and then drop the TS. But the
> 'data' consists of 100's of tables and indexes (not necessarily on
> those tables), with 4 possible owners.
>
> Is there a way to save a tablespace contents without using exp and
> TABLES=<lst>?
> Mike Riney (mriney_at_dircon.co.uk)
> -- Sheepishly observing the netiquette I forgot last time (but Im a
 newbie)
>
>
Received on Sat Mar 15 1997 - 00:00:00 CST