Re: Copy of Table

Mohammad wrote:

> Hi
>
> I need to know how can I make copy of a table in sql-plus (Oracal).
> And how Can I return this copy overwrite on oracle table.
>
> Thank you for you help
>
> Thanks
> Mohammad

Overwriting of tables is impossible.

You can create a copy in the same or a different schema with:

CREATE TABLE <new_table_name> AS
SELECT *
FROM <table_name>;

If you want something different you will need to be more specific and be sure to include Oracle version number.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)