Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: change owner
OK, thanks
"Daniel Morgan" <dmorgan_at_exesolutions.com> a écrit dans le message de news:
3D050708.554674C0_at_exesolutions.com...
> zeb wrote:
>
> > Hi,
> >
> > I have to change the owner of somes tables ....
> > what is the right way to do that ?
> >
> > conf.: oracle 8.1.7 on HP-UX 11.0
>
> Can't be done in 8.1.7 directly. You have several choices.
>
> 1. Create the new schema if it doesn't exist.
> 2. Log on as the current owner of the tables and ...
> GRANT SELECT ON <table_name> TO new_schema
> 3. Log on as the new schema owner
> 4. CREATE TABLE xyz AS
> SELECT *
> FROM old_schema.old_table_name;
>
> or
>
> EXPort followed by IMPort
>
> Only a few tables and not much data ... I'd use the first.
>
> Daniel Morgan
>
Received on Mon Jun 10 2002 - 15:12:24 CDT