DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Export and Import

  1. #1
    Join Date
    Oct 2000
    Posts
    42

    Question

    How do I export all tablespaces and schema object definitions of a database without the data for use on another node? All I wanted to do is recreate the tablespaces, constraints, roles etc on a new node. This is Unix, 8.1.6.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    use options
    full=y
    rows=n

    which exports the whole database(all the objects and definitions,grants etc) with no data.

Posting Permissions

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


Click Here to Expand Forum to Full Width