Help - Search - Members - Calendar
Full Version: How to Create Dump File
Oracle DBA Forums > Oracle > Oracle Forum
Raveendra_pune1
Hi all, Please Help me ...i have one user ...in this user there are 200 tables 20 function and some procedure ...i want to create dump file....user permission is RESOURCE.....please tell me how to create dum file and how to Import this dum file in anothere server

Thanks In Advance...?
Vugar
QUOTE (Raveendra_pune1 @ Jul 2 2008, 08:58 AM) *
Hi all, Please Help me ...i have one user ...in this user there are 200 tables 20 function and some procedure ...i want to create dump file....user permission is RESOURCE.....please tell me how to create dum file and how to Import this dum file in anothere server

Thanks In Advance...?



cmd>expdp system/system_password directories=DATA_pump_DIR schemas=user_name dumpfile=user.dbf
Littlewheat
Hi Raveendra_pune1,
u may use datapump.

Export part:
create run file: (for example: export_schema)

expdp PARFILE=export_schema.ctl

create control file: (for example: export_schema.ctl)

USERID="sys/password@DB_NAME as sysdba"
DUMPFILE=20080629.DMP
COMPRESSION=NONE
SCHEMAS=YOUR_SCHEMA(user_name)
LOGFILE=20080629_EXP.LOG


Default path for dumpfile /opt/oracle/product/10.2.0/db_1/rdbms/log
(and for log file)

Import part:
run file:

impdp PARFILE=import.ctl

Control file:

USERID="sys/password@DB_NAME as sysdba"
DUMPFILE=20080629.DMP
LOGFILE=20080629_IMP.LOG
aussie_dba
"i want to create dump file"

Take a dump with data pump:

http://www.dba-oracle.com/concepts/imports_exports.htm

Here are some other ways to take a dump:

http://www.dba-oracle.com/t_10046_tracing_events.htm
KSRK
you can use following shell command

expdp userid/pwd schemas=dbschema dumpfile=file.dmp logfile=file.log

This above one is shell commend so execute in the shell. once export is completed search "dpdump" folder in oracle installed directory where you can find your exported file with log.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.