Passing a schema registration to another

[Cristiano Gomes]

Environment information:
* Oracle version: 9i
* Operating system: Windows 2003

Good afternoon,

I have a database that has two equal schemas. I need to copy the contents of a table from a schema to the other. How should I do?

The tables have the same structure, I tried the way below, but I was not happy.

Select all

INSERT INTO TESTE (SELECT * FROM SCHEMA1.TAB) 
VALUES (SELECT * FROM SCHEMA2.TAB)

Thank you

[Trevisolli]

Brother,

Try in this way:

Select all

 
INSERT INTO schema2.TABLE AS SELECT * FROM schema1.TABLE; 

[Cristiano Gomes]

I tried this way and Oracle presented the error below.

Select all

ERROR at line 1: 
ORA-00926: missing VALUES keyword

Thank you

[iabrj]

Try this way:

Select all

INSERT INTO schema1.NomeTabela 
(SELECT * FROM schema2.NomeTabela);

[Cristiano Gomes]

Good afternoon

I think I need to infomer instead of * the name of the columns, as the tables of the two schemas have the same columns in different order.

Sincerely