Datapump backup steps?
Answer / kittu_chintu2005
Create a file structure @ oracle level by issuing the statement "create directory dpump_dir1 as '/disk01/oradata/mine/dpump'';" "grant read, write to user1, user2;"
@ OS "level mkdir -p /disk01/oradata/mine/dpump"
And then issue the statement @ OS level "expdp directory=dpump_dir1 dumpfile=xxxxx.dmp"
Is This Answer Correct ? | 3 Yes | 0 No |
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the recovery models for a database? : sql server DBA
which background process will run @ the time of creation of catalog database
why do we give pctfree and pctused in create table statement?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you record information about current session?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you create a user-defined lock?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
what functionality does oracle provide to secure sensitive information?
Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris