• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Oracle: Export jforum tables to another oracle database

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Farmers know to never drive a tractor near a honey locust tree. But a tiny ad is okay:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic