Re: change owner

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:07:40 CDT