Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Chown for Oracle ?? Giving schema objects to other user ?
Hi,
First of all, lets make 1 thing clear.
Were the objects imported using the user 'SYS' or 'SYSTEM' ?
Secondly, can you identify by object_names, the objects that shouldn't be in
the system tablespace ?
If so,
Make a list of tables that are to be moved to another tablespace.
May be the following query can help:
select owner, segment_name, segment_type from dba_segments
where tablespace_name = 'SYSTEM';
I am thinking along the lines of exporting those tables using exp.
If you need more help on exp you can type EXP HELP=Y.
Have you heard of T.O.A.D ?
If not download it from www.toadsoft.com, its a great tool.
The rule is, when you export tables, indexes, constraints are exported as
well.
So once you have exported the tables, drop the tables and precreate them
(and indexes as well) into the correct tablespace before doing an IMP.
Do an imp and your data will be loaded into the correct tablespaces this
time.
PS DONOt run this on a production system until you have tested everything thoroughly.
Peter Gross wrote in message
<910196581.16229.0.nnrp-01.c1edb16f_at_news.demon.co.uk>...
>One of our developers has imported there work into the SYSTEM user by
>mistake. Before realising a number of changes have been made to the objects
>(meaning that I can't just drop and then re-import the objects).
>
>Can anyone suggest how I (selectively) copy the objects from the SYSTEM
user
>to the DEV user ?
>
>I was thinking that CREATE AS might be an option, but surely this wont be
of
>use for the other objects such as synonyms, constraints, indexes, etc.
>
>Any assistance greatfully received.
>
>
>
>
Received on Wed Nov 04 1998 - 12:43:50 CST