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 DEBIAN
o2info
o2info(1) OCFS2 Manual Pages o2info(1)NAME
o2info - Dump OCFS2 file system information on disk.
SYNOPSIS
o2info [-C|--cluster-coherent] [--fs-features] [--volinfo] [--mkfs] <device or file>
DESCRIPTION
o2info is designed to be an information tool, to display OCFS2 file system information on disk. Its main goal on one hand, is to provide a
tool to display fs info in a comprehensive way and providing the information which may be missing in debugfs.ocfs and tunefs.ocfs2 such as
global bitmap free space fragmentation and free inode info for each slot, on the other hand, it also aims to become a info tool(not an
administration one), which therefore allows all users who may have no read privilege on the underlying device to use the utility. In prac-
tice, 'o2info /path/to/file/on/ocfs2/vol' use a new OCFS2_IOC_INFO ioctl to get info from fs for a mounted case. For a privileged user(e.g,
root), the same info however, can also be accessed by 'o2info /dev/sdxN' to direcly manipulate the raw device.
OPTIONS -C, --cluster-coherent
Enable cluster (in)coherency for mounted case, means it will attempt to acquire a global PR lock when querying info from a cluster
filesystem, which may degrade the performance, default is none cluster-coherency.
--fs-features
List all compat, incompat and ro-compat fs features on OCFS2 filesystem.
--volinfo
Dump basic volume information, such as blocksize, clustersize, volume label and UUID etc.
--mkfs Dump an original format of mkfs.ocfs's arguments, importantly, which can be used directly as a fresh mkfs retry: #mkfs.ocfs2
"$(o2info --mkfs /dev/name/or/path/of/file)" /dev/sdaX
-V, --version
Show version and exit.
-h, --help
Display help and exit.
EXAMPLES
[oracle@node1 ~]# o2info --volinfo /storage/testfile # For none-privileged users.
[root@node1 ~]# o2info --volinfo /dev/sda1
Label: ocfs2-volume
UUID: 976D8E630B3A4F1F95497311A92901FC
Block Size: 4096
Cluster Size: 4096
Node Slots: 4
Features: backup-super strict-journal-super sparse inline-data xattr
Features: unwritten
SEE ALSO debugfs.ocfs2(8)tunefs.ocfs2(8)AUTHORS
Oracle Corporation
COPYRIGHT
Copyright (C) 2010 Oracle. All rights reserved.
Version 1.6.4 October 2010 o2info(1)