Sponsored Content
Full Discussion: DB2 Export and Import Oracle
Homework and Emergencies Homework & Coursework Questions DB2 Export and Import Oracle Post 302990222 by Sonny_103024 on Tuesday 24th of January 2017 02:33:06 AM
Old 01-24-2017
Thanks gandolf989

---------- Post updated at 01:25 PM ---------- Previous update was at 01:17 PM ----------

Hi All,

Anyone please help? I run my import script in unix but im not sure why its running to long? so I cancel the job.

can anyone tell me what is the problem of my script?

Code:

Code:
sqlldr userid/psswrd control=/export/home/user/Import_Script/Table.ctl


Code:
LOAD DATA
INFILE '/export/home/user/Export_Data/XTABLE.DEL'
APPEND
INTO TABLE CP_TABLE
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
( TABLE_NO, TABLE_NO_CARD, TABLE_OPEN_DATE, TABLE_AUTO_STOP, TABLE_MOD_DATE, TABLE_USER_ID, CHECKSUM )


my data (XTABLE.DEL)

Code:
+01.,+00000002.,"20130101","N","        ","root      "," "
+02.,+00000001.,"20130101","N","        ","root      "," "
+03.,+00000001.,"20130101","N","        ","root      "," "
+04.,+00000001.,"20130101","N","        ","root      "," "
+05.,+00000003.,"20130101","N","        ","root      ",""
+06.,+00000001.,"20130101","N","        ","root      "," "
+07.,+00000000.,"20130101","N","        ","root      "," "
+08.,+00000001.,"20130101","N","        ","root      "," "
+09.,+00000001.,"20130101","N","        ","root      "," "
+10.,+00000001.,"20130101","N","        ","root      "," "
+11.,+00000001.,"20130101","N","        ","root      "," "
+12.,+00000001.,"20130101","N","        ","root      "," "
+13.,+00000001.,"20130101","N","        ","root      "," "
+14.,+00000000.,"20130101","N","        ","root      "," "
+15.,+00000001.,"20130101","N","        ","root      ",""

do i need to add commit in my script? is it require?

---------- Post updated at 03:33 PM ---------- Previous update was at 01:25 PM ----------

Thank you Don Cragun.. That things will guide me for my next problem encounter.

Last edited by Don Cragun; 01-24-2017 at 02:42 AM.. Reason: Add CODE tags.
 

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
chroot(1M)																chroot(1M)

NAME
chroot - change root directory for a command SYNOPSIS
newroot command DESCRIPTION
The command executes command relative to the newroot. The meaning of any initial slashes in path names is changed for command and any of its children to newroot. Furthermore, the initial working directory is newroot. Note that command suffixes that affect input or output for the command use the original root, not the new root. For example, the command: locates file relative to the original root, not the new one. The command variable includes both the command name and any arguments. The new root path name is always relative to the current root. Even if a is currently in effect, the newroot argument is relative to the current root of the running process. This command is restricted to users with appropriate privileges. EXTERNAL INFLUENCES
International Code Set Support Single- and multibyte character code sets are supported. WARNINGS
command cannot be in a shell script. Exercise extreme caution when referring to special files in the new root file system. does not search the environment variable for the location of command, so the absolute path name of command must be given. When using to establish a new environment, all absolute path name references to the file system are lost, rendering shared libraries inac- cessible. If continued access to shared libraries is needed for correct operation, the shared libraries and the dynamic loader be copied into the new root environment. SEE ALSO
chdir(2), chroot(2). STANDARDS CONFORMANCE
chroot(1M)
All times are GMT -4. The time now is 02:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy