Take database schema dump and export
Today I need to migrate my schema from oracle xe in my system to another system which is a Linux box. I had to revisit a number of command, which is quite helpful. I used the export import utility provided by oracle. Its quite easy and straight forward. Step 1 Exporting schema to a dump file D:\Oracle\db\app\oracle\product\10.2.0\server\BIN>expdp system/**** schemas= hr directory=C:\Temp dumpfile=hrdump.dmp logfile=rexp.log Export: Release 10.2.0.1.0 - Production on Monday, 31 January, 2011 5:51:24 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio n ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39087: directory name C:\TEMP is invalid Then l reliesed that oracle does not know my directory. Then create this directory by login to database with user name and password system/****** sqlplus> create directory hrdump as 'C:\Te...