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?

Quote:

---

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

what is option in export that only export table structure?

exp help=y

would it be:
exp USERNAME/PASSD grants=Y owner=scott rows=N indexes=N.
will this exports only table structure for user scott. Thanks.

Quote:

---

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