Hi!
We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1
The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive... (1 Reply)
Hi guys:
I have a an oracle job which uses 10 parallel hints and would like to killit when it hangs. I want to kill all the processes that have been spawned. what I do right now is get the pid of the scheduler process which initiated theis job and the do a ps -ef| grep 'pid' and trace through... (1 Reply)
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Hi,
How do i export selected Oracle database schemas from HpUnix?
Is it possible to export it to a windows shared drive?
If so how do i do it?
Pls advice.
Thanks in advance. (4 Replies)
Hi
I have an oracle 7.3.4 running on an aix 4.3, I need to make a full export of the db and I haven't space on disk.
Can I export directly to a tape drive?
Has anybody a script to do so or something that can help me to?
thank you very much (1 Reply)
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
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)
i have say x number of procedure to run, ie i have one procedure which accepts variable and i need that to run in parallel and capture the error code if in case if it fails through the unix.
sqlplus <EOF> exec test_t (abc,124); </EOF>
sqlplus <EOF> exec test_t (abc,125); </EOF>
sqlplus <EOF>... (2 Replies)
Hi,
Trying to run the Oracle Proc in parallel, but not working.. below code runs each call of the procedure and its coming out of the loop before its completion and printing the last statement! not waiting for the sqlplus to complete.
for name in `cat abc.txt`
do
(sqlplus -s ... (3 Replies)
Discussion started by: ATWC
3 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::oracle::wherejoins5.18
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2013-07-12 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)