Sponsored Content
Full Discussion: DB2 Export and Import Oracle
Homework and Emergencies Homework & Coursework Questions DB2 Export and Import Oracle Post 302990260 by rbatte1 on Tuesday 24th of January 2017 06:39:17 AM
Old 01-24-2017
The import will probably take longer than a plain export because it is writing. Not only does this require the data to be committed (i.e. to disk, not a query commit) but this will write to redo logs, perhaps extend tables etc. beware that cancelling your loader with do one of two things:-
  • Commit an incomplete load (which you might need to tidy up)
  • Roll-back, which can also take a long time.

For clarity,
  • is this an extraordinarily long delay?
  • can you still connect to the database with another session?
It might be that the redo/undo areas are full or if redo logs are moved to disk, the filesystem that holds them might be full. Have a look at the oracle logs to see if that's the case.


The sqlldr will commit at the end anyway. I think you can use the parameter ROWS=1000 or a suitable number on sqlldr to force more regular commits, at which point you can use another session to count the rows imported into your table so far.



Does that help?
Robin
 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Local NFS import / re-export using automount?

Hi, Can I do the following: On SunOS 5.8 /etc/vfstab: remote-host:/Volumes/webdata - /export/home/webdata nfs - yes rw,vers=3,soft,intr,bg,timeo=600 In /etc/auto_direct: /home/science $HOST:/export/home/webdata/science /home/science-edu ... (2 Replies)
Discussion started by: bloyall
2 Replies

2. Solaris

Export/import ZFS ACL's

I've been wondering about this one, is there any way to do the following with ZFS ACL's (i.e. "copy" the ACL over to another file)? getfacl /bla/dir1 | setfacl -f - /bla/dir2 I know about inheritence on dirs, it doesn't work in this scenario I'm working on. Just looking to copy the ACL's. ... (3 Replies)
Discussion started by: vimes
3 Replies

3. Shell Programming and Scripting

manipulate text for openldap import/export question.

Hey guys.. I am not sure if this is the right place to post this - but here goes. I need to manipulate an openldap export to match a different schema so that I can import into that system. Basically - its just text manipulation. I have gotten alot of it done just by using simple sed, but I am sorta... (0 Replies)
Discussion started by: i2ambler
0 Replies

4. Shell Programming and Scripting

Error: SQL3100W while export in DB2

Problem has been resolved (7 Replies)
Discussion started by: ustechie
7 Replies

5. Shell Programming and Scripting

export / import

I have a calling script which consists of calls to other scripts via the sh command. ie vi callscript.sh sh smallscript1.sh extra unix commands sh smallscript2.sh exit In smallscript1, I prompt for a filename, which I handle via :- read f1 export f1 I then need... (5 Replies)
Discussion started by: malts18
5 Replies

6. UNIX for Dummies Questions & Answers

Import and export PGP/GnuPG keys

Hi, I need to export an existing PGP key and import it into GnuPG on a different machine. This is how I did the export: pgp -kx myuser _myuser_public pgp -kx myuser _myuser_private secring.skr (this is from the pgp installation directory that contains secring.skr). This produced two... (0 Replies)
Discussion started by: imchi
0 Replies

7. Solaris

Zpool import/export error

A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he... (2 Replies)
Discussion started by: beantownmp
2 Replies

8. Homework & Coursework Questions

DB2 Export and Import Oracle

Hi Guys, I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle. db2 connect to Tablename user id using psswrd db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA" db2 "EXPORT TO... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

9. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

10. Shell Programming and Scripting

Array - Export/Import in global environment variables.

Hello. During startup /etc/bash.bashrc.local generates some array ..... source /.../.../system_common_general_array_env_var ..... The file system_common_general_array_env_var contains : LEAP_VERSION='42.3' ARRAY_MAIN_REPO_LEAP=('zypper_local' 'openSUSE-Leap-'"$LEAP_VERSION"'-Non-Oss' ... (2 Replies)
Discussion started by: jcdole
2 Replies
Parity(3)						User Contributed Perl Documentation						 Parity(3)

NAME
String::Parity, setEvenParity, setOddParity, setSpaceParity, setMarkParity, isEvenParity, isOddParity isSpaceParity, isMarkParity, Even- Bytes, OddBytes, SpaceBytes, MarkBytes, showParity, showMarkSpace - Parity (odd/even/mark/space) handling functions SYNOPSIS
use String::Parity; use String::Parity qw(:DEFAULT /show/); DESCRIPTION
setEvenParity LIST Copies the elements of LIST to a new list and converts the new elements to strings of bytes with even parity. In array context returns the new list. In scalar context joins the elements of the new list into a single string and returns the string. setOddParity LIST Like setEvenParity function, but converts to strings with odd parity. setSpaceParity LIST Like setEvenParity function, but converts to strings with space (High bit cleared) parity. setMarkParity LIST Like setEvenParity function, but converts to strings with mark (High bit set) parity. EvenBytes LIST Returns the number of even parity bytes in the elements of LIST. OddBytes LIST Returns the number of odd parity bytes in the elements of LIST. SpaceBytes LIST Returns the number of space parity bytes in the elements of LIST. MarkBytes LIST Returns the number of mark parity bytes in the elements of LIST. isEvenParity LIST Returns TRUE if the LIST contains no byte with odd parity, FALSE otherwise. isOddParity LIST Returns TRUE if the LIST contains no byte with even parity, FALSE otherwise. isSpaceParity LIST Returns TRUE if the LIST contains no byte with mark parity, FALSE otherwise. isMarkParity LIST Returns TRUE if the LIST contains no byte with space parity, FALSE otherwise. showParity LIST Like setEvenParity function, but converts bytes with even parity to 'e' and other bytes to 'o'. The function showParity must be imported by a specialised import list. showMarkSpace LIST Like setEvenParity function, but converts bytes with space parity to 's' and other bytes to 'm'. The function showMarkSpace must be imported by a specialised import list. NOTES
Don't use this module unless you have to communicate with some old device or protocol. Please make your application 8 bit clean and use the internationally standardised ISO-8859-1 character set. AUTHOR
Winfried Koenig <win@in.rhein-main.de> SEE ALSO
perl(1), Exporter(1) perl v5.8.0 1996-12-10 Parity(3)
All times are GMT -4. The time now is 07:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy