Re: Copy tables and indexes etc from one db to another

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

>>> Roland.Skoldblom_at_ica.se 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: Roland.Skoldblom_at_ica.se 

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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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).