Richard Elliott wrote:
>
> I have a database with two very large tables and 35 smaller tables. I want
> to use export to create backups of the database. Currently I export by
> user. I want to change the user on the the two very large tables so I AFAIK there is no way to change the owner (schema) of a table. Your best bet is to export the tables from the existing schema then import into the new schema. Once you are sure everything in the new tables is fine you can then DROP the old tables. You can also simply connect to the new schema & execute a CREATE TABLE AS SELECT * FROM <oldschema>.<table>@<db_link> -- but this method requires a database link & you only get the table
& its rows -- no constraints etc.
--
Vincent Ventrone
DBA, Dept. R101
vav_at_mitre.org
(781) 271-7048
The MITRE Corp. | "...In my opinion there's nothing
M/S C020 | in this world beats a '52 Vincent
202 Burlington Rd. | and a redheaded girl."
Bedford, MA 01730 | -- Richard Thompson
Received on Tue May 11 1999 - 17:10:16 CDT
