Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Halp!!! Import data: new machines with three disks and different table spaces from export

Re: Halp!!! Import data: new machines with three disks and different table spaces from export

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 3 Oct 1998 10:43:13 -0500
Message-ID: <6v5gmh$o4m$1@garnet.tc.umn.edu>


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/

--  



Steven Hauser, hause011_at_tc.umn.edu
Phone: (612)626-7135
Fax:   (612)625-6853

---------------------------------------------------------
Received on Sat Oct 03 1998 - 10:43:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US