Exporting/Importing Oracle Schemas
August 2nd, 2007 by Matt
I originally found this information on a post at TechTarget, I wanted to reference the commands here in case the original article disappears. The original article is a lot more in depth and includes different scenarios, I recommend you read this before you start.
Exporting an Oracle schema
exp user@server file=user_a.dmp log=user_a.log owner=a
Importing an Oracle schema
imp user@server file=user_a.dmp log=imp.log fromuser=a touser=b
Posted in Oracle
August 2nd, 2007 at 11:38 am
I was hoping I could do a quick backup of my schema to my iphone through the oracle web sqlplus (ugh, I hate that thing), but apparently the web sqlplus doesn’t allow this. Oh well. Thanks!