Oracle: Export jforum tables to another oracle database

[Migrated From Jforum.net]

hi,
how can I export all jforum tables to another oracle database.
Is there something special about it or can I just do an export/import for all tables beginning with jforum.

(I know I have to change the db-connection string)

thx
[originally posted on jforum.net by shadow_empire]

[Migrated From Jforum.net]

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]

[Migrated From Jforum.net]

Here is the howto I did

First purge content in the target database with oracle_db_struct_drop.sql.
Then create the tables with oracle_db_struct.sql

Then from a shell:

set NLS_LANG=AMERICAN_AMERICA.UTF8
exp sourceschema/password@sourceDB owner=owner file=forum.dmp log=forum_exp.log
imp targetschema/password@targetDB fromuser=forum touser=targetschema file=forum.dmp log=forum_IMP.log ignore=y CONSTRAINTS=Y

After this you have to update (restar) the deployment!

[originally posted on jforum.net by shadow_empire]