SQL & PL/SQL

i wanted to share some points about export/import tables in oracle.


we have two environments one is development and integrated user acceptance test (UAT).
we have finalized table structures with data in UAT. i wanted to move from UAT to Development.
i found some commends in google. I tried but I am not able to export and then its throwing some errors.
i am explaining below what i want to do and what i want did.

Please provide solution what i need to do.



admin credentials in UAT


username :venkat_admin

password :venkat_admin


UAT user/schema

username : ods_inb_stg
password : ods_inb_stg


development environment credentials

admin user name : dev_admin
password : dev_admin

Development user/schema

username :ods_inb_dev
password :ods_inb_dev


Above mentioned schema names i want move data from UAT (ods_inb_stg) to development (ods_inb_dev)

I logged in uat ods_inb_stg user and then

I used this command

Exp ods_inb_stg/ods_inb_stg file=party_pt_address.expdat tables=(party,party_address)
log=party_pt_address.log;

getting error


Unknown command beginning "exp ods_inb_stg/..." - rest of line ignored.


What should I do any one help.


One more thing i have more than 100 tables how to export all tables and which is the easiest way and how to do it.


Thanks in Advance
Venkat