I have a script which gives the output of schemas in Oracle DB :
#!/bin/ksh
ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL
do
if ; then
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:.
... (0 Replies)
Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue (0 Replies)
Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue..
I need it asap thats y posted here
Thanks (5 Replies)
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,
I need to import more than 250K of records to another Database(Oracle).But I want particular column value to be changed in the destination table. Is it possible to do this during export or import process with out modifying data from original table.I do not want to run Update manually.
... (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)
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (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 V7
dump
DUMP(1M)DUMP(1M)NAME
dump - incremental file system dump
SYNOPSIS
dump [ key [ argument ... ] filesystem ]
DESCRIPTION
Dump copies to magnetic tape all files changed after a certain date in the filesystem. The key specifies the date and other options about
the dump. Key consists of characters from the set 0123456789fusd.
f Place the dump on the next argument file instead of the tape.
u If the dump completes successfully, write the date of the beginning of the dump on file `/etc/ddate'. This file records a separate
date for each filesystem and each dump level.
0-9 This number is the `dump level'. All files modified since the last date stored in the file `/etc/ddate' for the same filesystem at
lesser levels will be dumped. If no date is determined by the level, the beginning of time is assumed; thus the option 0 causes the
entire filesystem to be dumped.
s The size of the dump tape is specified in feet. The number of feet is taken from the next argument. When the specified size is
reached, the dump will wait for reels to be changed. The default size is 2300 feet.
d The density of the tape, expressed in BPI, is taken from the next argument. This is used in calculating the amount of tape used per
write. The default is 1600.
If no arguments are given, the key is assumed to be 9u and a default file system is dumped to the default tape.
Now a short suggestion on how perform dumps. Start with a full level 0 dump
dump 0u
Next, periodic level 9 dumps should be made on an exponential progression of tapes. (Sometimes called Tower of Hanoi - 1 2 1 3 1 2 1 4 ...
tape 1 used every other time, tape 2 used every fourth, tape 3 used every eighth, etc.)
dump 9u
When the level 9 incremental approaches a full tape (about 78000 blocks at 1600 BPI blocked 20), a level 1 dump should be made.
dump 1u
After this, the exponential series should progress as uninterrupted. These level 9 dumps are based on the level 1 dump which is based on
the level 0 full dump. This progression of levels of dump can be carried as far as desired.
FILES
default filesystem and tape vary with installation.
/etc/ddate: record dump dates of filesystem/level.
SEE ALSO restor(1), dump(5), dumpdir(1)DIAGNOSTICS
If the dump requires more than one tape, it will ask you to change tapes. Reply with a new-line when this has been done.
BUGS
Sizes are based on 1600 BPI blocked tape. The raw magtape device has to be used to approach these densities. Read errors on the filesys-
tem are ignored. Write errors on the magtape are usually fatal.
DUMP(1M)