Creating Staging Database

[Bore]

I would recommend using DBCA.
1)At the source database, start dbca
2)enter "Manage Templates"
3)Create template from the source database INCLUDING Structure as well as data
4)go to the $ORACLE_HOME/assistants/dbca/templates
identify all the files, containng in their name the template name you gave during the template creation and copy them to the destination machine
$ORACLE_HOME/assistants/dbca/templates
5) At the destination machine start DBCA
6) Select create database. In the list of templates, bellow OLTP, DWH, general purpose, you will see your template name. Select it
7) Follow the wizard, complete the database creation
8) Check if all the data users etc are ok and be happy :-)

NOTE: That works only if the source and destination OS is same
P.S.
Some more details about DBCA templates here
http://download-uk.oracle.com/docs/c...te.htm#1000144