RE: multiple concurrent imports into the same database

From: Figueiredo, Pedro <PFigueiredo_at_europeantelecom.at>
Date: Sun, 3 Sep 2000 11:40:05 -0000
Message-Id: <10608.116125@fatcity.com>

Hi,

Yes, it's possible... using different sessions. Even simultaneously into the same table (with parallel=3DTRUE). Usually it speeds thinks up. It is advisable to have .dat files that = you are
importing on different physical locations.

Take a look on Oracle8i Utilities Release 8.1.5, Part II, specially = chapter
8.

Bye

Pedro Figueiredo

-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] Sent: s=E1bado, 2 de Setembro de 2000 21:35 To: Multiple recipients of list ORACLE-L Subject: multiple concurrent imports into the same database

Just to be curious,

Is it possible to run say, two, three, four, five simultaneous imports against the same database?

Would that speed things up?

Thanks.

Another wacky idea brought to you by

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

--=20
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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). Received on Sun Sep 03 2000 - 06:40:05 CDT