Does dbexport use tmp space?

Posted in 2018

Topics: Migration, Import/Export & Data Conversion

BENJI LONG — Sat, 10 Feb 2018 17:18:11 — source: IIUG Forums & Mailing Lists

When doing a dbexport to a certain file system, does it also use tmp space while doing the work?

↪ replying to BENJI LONG

Mike Walker — Sat, 10 Feb 2018 17:42:26 — source: IIUG Forums & Mailing Lists

I would not have thought so - at least not significantly. It should just be producing schemas and running selects against each table. A dbimport would because of index builds, etc. I would be interested if it you are seeing anything different. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Saturday, February 10, 2018 10:18 AM To: ids@iiug.org Subject: Does dbexport use tmp space? [40670] When doing a dbexport to a certain file system, does it also use tmp space while doing the work? **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Mike Walker

Lester Knutsen — Sat, 10 Feb 2018 18:43:28 — source: IIUG Forums & Mailing Lists

You could run onstat -D and monitor the reads and writes to your temp dbspace while doing an export to find out. Regards - Lester On 2/10/18 12:42 PM, Mike Walker wrote: > I would not have thought so - at least not significantly. It should just be > producing schemas and running selects against each table. A dbimport would > because of index builds, etc. > > I would be interested if it you are seeing anything different. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI > LONG > Sent: Saturday, February 10, 2018 10:18 AM > To: ids@iiug.org > Subject: Does dbexport use tmp space? [40670] > > When doing a dbexport to a certain file system, does it also use tmp space > while doing the work? > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________

↪ replying to Lester Knutsen

BENJI LONG — Sat, 10 Feb 2018 19:24:04 — source: IIUG Forums & Mailing Lists

Ok, thanks

Related threads

Glossary

dbexport / dbimport