OraFAQ Forum: Server Utilities » move data at the same schema

Home » RDBMS Server » Server Utilities » move data at the same schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

move data at the same schema [message #70742]

Fri, 19 July 2002 15:24

NiGger
Messages: 6
Registered: July 2002

Junior Member

Hello
I can't find any documentation about how to move data between two tables at the same schema , obviously the tables are identicals.
can anybody help me?

Thanks in advanced

NiGger

Report message to a moderator

Re: move data at the same schema [message #70744 is a reply to message #70742]

Fri, 19 July 2002 15:34

ctg
Messages: 146
Registered: July 2002

Senior Member

do you simply what to copy data from 1 table to another?

INSERT INTO table2
SELECT * FROM table1;

Report message to a moderator

Re: move data at the same schema [message #70752 is a reply to message #70742]

Sat, 20 July 2002 01:27

sunil bhola
Messages: 58
Registered: July 2002

Member

simply!..
create table sunil1 as select *from sunil;

Report message to a moderator

Previous Topic:	Re: urgent
Next Topic:	Can Oracle 8.1.7 client export tool be used for exporting an Oracle 7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 19:25:50 CDT 2024