I can't speak specifically about Oracle (don't use it), but I do know that if you aren't changing versions, etc. Just transferring the schema and data and changing the connect info will work. I've done this with MS SQL's DTD tools with no problems.
If you have to transfer it via a set of import/export SQL scripts, you may need to figure out the foreign key constraints and import the "master" tables before the dependent ones.
Also, some DBs don't allow autoincrement fields to be imported without some special handling (e.g. MySQL requires a non-statndard REPLACE statement to do this, MS SQL has a command like IDENTITY OFF/ON that the INSERT statements have to be wrapped in to work. [originally posted on jforum.net by monroe]