Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    Unanswered: onunload and load utility

    Hi,
    I am having a database with tables split accross the Dbspaces. When i take a unload of the Database using onunload and reload using onload the tables, whole database is going into a single dbspace(which i specify) or root dbs if not specified. is there any way of preserving the dbspaces of the tables.


    bye.
    zxczxczc

  2. #2
    Join Date
    May 2004
    Posts
    1

    try this...

    dbschema with some parameters can dump some storage details...try to use in dbschema xxx.exp/xxx.sql...

  3. #3
    Join Date
    Aug 2003
    Posts
    68
    dbexport <dbname> -ss

    This will unload the data to ascii files and create the sql that puts the objects in the proper dbspaces.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •