Home » RDBMS Server » Server Utilities » Export/import
Export/import [message #71182] Sat, 21 September 2002 05:48 Go to next message
Vishal
Messages: 86
Registered: August 2000
Member
Hi,
I have two tables(similar structute) in my oracle8 database.One has data,other is empty.Now,i want to import data of one table into the empty table.how can i do it
thanks

Report message to a moderator

Re: Export/import [message #71184 is a reply to message #71182] Sat, 21 September 2002 08:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
insert into table1
(select * from table2);

Report message to a moderator

Previous Topic: Exporting to a file with date stamp...
Next Topic: Re: import/export issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 12:23:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.