01-24-2017
Sonny,
How long is too long to run? How many indexes do you have on the table? How many constraints, including foreign keys do you have? How many row level triggers do you have and what do they do? How many rows are you inserting? Can you use grid to trace what is happening in the import?
I have not seen enough information to give you a meaningful answer. Also this seems like a question better served on an Oracle Forum than a Unix/Linux forum.
This User Gave Thanks to gandolf989 For This Post:
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
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
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
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
Problem has been resolved (7 Replies)
Discussion started by: ustechie
7 Replies
5. Shell Programming and Scripting
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
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
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
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
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
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
LEARN ABOUT PHP
odbc_foreignkeys
ODBC_FOREIGNKEYS(3) 1 ODBC_FOREIGNKEYS(3)
odbc_foreignkeys - Retrieves a list of foreign keys
SYNOPSIS
resource odbc_foreignkeys (resource $connection_id, string $pk_qualifier, string $pk_owner, string $pk_table, string $fk_qualifier,
string $fk_owner, string $fk_table)
DESCRIPTION
Retrieves a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the
specified table
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $pk_qualifier
- The primary key qualifier.
o $pk_owner
- The primary key owner.
o $pk_table
- The primary key table.
o $fk_qualifier
- The foreign key qualifier.
o $fk_owner
- The foreign key owner.
o $fk_table
- The foreign key table.
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oPKTABLE_QUALIFIER
oPKTABLE_OWNER
oPKTABLE_NAME
oPKCOLUMN_NAME
oFKTABLE_QUALIFIER
oFKTABLE_OWNER
oFKTABLE_NAME
oFKCOLUMN_NAME
oKEY_SEQ
oUPDATE_RULE
oDELETE_RULE
oFK_NAME
oPK_NAME
If $pk_table contains a table name, odbc_foreignkeys(3) returns a result set containing the primary key of the specified table and all of
the foreign keys that refer to it.
If $fk_table contains a table name, odbc_foreignkeys(3) returns a result set containing all of the foreign keys in the specified table and
the primary keys (in other tables) to which they refer.
If both $pk_table and $fk_table contain table names, odbc_foreignkeys(3) returns the foreign keys in the table specified in $fk_table that
refer to the primary key of the table specified in $pk_table. This should be one key at most.
PHP Documentation Group ODBC_FOREIGNKEYS(3)