I am facing one problem related to importing Oracle Dump file.
We have two different version of AIX boxes with oracle (version 10.2.0.4.0) installed.
On one AIX box (version 6.1) we are creating oracle dump file (*.dmp) using oracle exp utility and importing it onto another AIX box (version 5.3) using imp utility of oracle.
We are getting below error :
Any pointer would be highly appreciated.
Thanks & Regards
Gunjan.
Last edited by Don Cragun; 12-26-2014 at 12:37 PM..
Reason: Add CODE and ICODE tags.
My development team has been trying to figure out how to import a unix data dump into SQL Server or convert it into an intermediate file format for several days.
The data dump in question looks like this:
$RecordID: 1<eof>
$Version: 1<eof>
Category: 1<eof>
Poster: John Doe<eof>... (7 Replies)
Hi,
I am trying to import 22 .dmp files but facing the problem with the last table file it never ends the import command, only the table is created but the rows of the table don't get imported.
This is the problem with only ine table rest 21 tables are being imported properly.
Thanks in... (2 Replies)
Hi In SunOS the gdb command outputs the following info.
---Type <return> to continue, or q <return> to quit---
Reading symbols from /opt/dcs_5.1/lib/libssl.so...done.
Loaded symbols for /opt/dcs_5.1/lib/libssl.so
Reading symbols from /opt/dcs_5.1/lib/libcrypto.so...done.
Loaded symbols for... (1 Reply)
Hi for all!
I need for my job one shell script very concrete about connection to oracle databases and writing to text file.
Well I tell you:
1.- I must read a file as parameter from linux interface:
> example.sh fileToRead
2.-I must read line to line in "fileToRead" and take a... (9 Replies)
I got a issue with running the following script below if I remove the inserts and alter table the tables will install just fine but if I try and do the full thing in one go i get the below error dose any one have any ideas on this problem?
its got me spinning, thanks.
REM
REM List of... (1 Reply)
Dear All,
I am trying to backup Databases in my company which installed on AIX oracle 10g. From the start they have not used the archives to backup DB. Instead they use expdp utility to export the data in to dump file and rename the file extension to .tmp and ftp to another machine to compress... (5 Replies)
Hi All,
I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.
Is that possible in oracle. What will be the command for that? (6 Replies)
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
1)We have 2 node cluster RAC on AIX:
->test1
->test3
2) After rebooting server both the node sequentailly, we are getting below error from errpt command :
# errpt |more
IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION
FE2DEE00 0901223914 P S SYSXAIXIF DUPLICATE IP ADDRESS... (2 Replies)
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
LEARN ABOUT SUSE
apache::session::oracle
Session::Oracle(3) User Contributed Perl Documentation Session::Oracle(3)NAME
Apache::Session::Oracle - An implementation of Apache::Session
SYNOPSIS
use Apache::Session::Oracle;
#if you want Apache::Session to open new DB handles:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:sessions',
UserName => $db_user,
Password => $db_pass,
Commit => 1
};
#or, if your handles are already opened:
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh,
Commit => 1
};
DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the
documentation for Apache::Session::Store::Oracle for more details.
USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to
either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have
adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order
to make you think about this problem.
This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default
maximum is 8 KB.
AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>.
SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session
perl v5.12.1 2007-09-28 Session::Oracle(3)