>Hello everyone,
>
>I need to copy a content of a table to another table in a different database.
>I have never done it and if anybody knows I would appreciated if can guide me to accomplish it.
>Both tables have the same data structure.
>
>Thanks,
>Sergio
Are you copying the rows to another table in the same Oracle instance? What I mean is this in the same Oracle instance? If so, the TO user needs SELECT privilege on the table of the FROM user. Then you can issue the following SQL:
INSERT INTO USER2.MYTABLE (SELECT * FROM USER1.MYTABLE)
If the USER2 table is empty you can drop it, and create the table to guarantee exact duplication:
CREATE TABLE USER2.MYTABLE AS SELECT * FROM USER1.MYTABLE
Mark McCasland
Midlothian, TX USA