Roland, That all depends is a valid answer. If the tables are small and few a full export/import count be quick if the table are not created on the new server. If the tables are large you might run into the file size limitation of the OS and then an insert/select across a database link might be the answer. If the tables are large you might want to do an export with the select option to get portions of the data at a time. If the databases are remotely located a copy across the database link could be faster than an export, copy to tape, mail the tape, copy from tape, and import the data. With no specific information given you will get no specific answers. Generally an export/import is the fastest to move data from one location to another. ROR mª¿ªm
>>> [EMAIL PROTECTED] 04/05/02 08:18AM >>> Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).