Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Halp!!! Import data: new machines with three disks and different table spaces from export
Yes you can get index and tables from the Oracle import 'indexfile=tables.sql'
parameter, however the rest of your grants, Pl/Sql, etc are not there.
If you want your full SQL DDL you have to extract it with a program.
I have a script to get this out at:
http://www.tc.umn.edu/nlhome/m031/hause011/
--
Phone: (612)626-7135 Fax: (612)625-6853Received on Sat Oct 03 1998 - 10:43:13 CDT
---------------------------------------------------------