Wednesday, January 21, 2009

To Export Dmp File From Database

1-export schima
exp "system/manager@database_name" file="file_name.dmp" log="file_name.log" owner=owner_name STATISTICS=NONE ;
2-export table
exp system/manager@database_name STATISTICS=NONE file=file_name.dmp log=file_name.log TABLES=(owner_name.table_name);

No comments: