migrating db from 9i to 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: migrating db from 9i to 10g

  1. #1
    Join Date
    Aug 2000
    Posts
    12

    migrating db from 9i to 10g

    All,
    I want to just migrating table structures for 1 user to the new db (10g). I am thinking of doing this,
    create user on new db. export just the table structures and import it into new db. Any suggestions?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331

    Re: migrating db from 9i to 10g

    Originally posted by bany1
    All,
    I want to just migrating table structures for 1 user to the new db (10g). I am thinking of doing this,
    create user on new db. export just the table structures and import it into new db. Any suggestions?
    that will work, good way of doing it

  3. #3
    Join Date
    Aug 2000
    Posts
    12

    what options in export

    what is option in export that only export table structure?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    exp help=y
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2000
    Posts
    12
    would it be:
    exp USERNAME/PASSD grants=Y owner=scott rows=N indexes=N.
    will this exports only table structure for user scott. Thanks.
    Last edited by bany1; 12-08-2004 at 01:41 PM.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Originally posted by bany1
    would it be:
    exp USERNAME/PASSD grants=Y owner=scott rows=N indexes=N.
    will this exports only table structure for user scott. Thanks.
    if you want tne entire structure you want indexes=y rows=n will do what you want

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