migrating db from 9i to 10g

[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?

[davey23uk]

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

[bany1]

what is option in export that only export table structure?

[marist89]

exp help=y

[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.

[davey23uk]

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