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

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

"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

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.