Re: Something better than dbimport

You could go through the pain of figuring out all of the constraint issued and unload all of the files using HPL or unload and then load them back in using HPL or load but I would not recommend it. Dbexport does all of this work for you, the only cost is time. When I was a DBA on a Oracle/PeopleSoft project we had to use export/import to clone databases. It took a long time (no pun intended) but that was/is the cost of cloning databases. In the end it is a lot faster than using Data Mover ;) SC > I have a 7gb PeopleSoft database which will grow to 14gb with a month > or two. We frequently make copies of databases and create new > databases. Dbimport seems to be awfully slow with some of my large > tables and overall in general. > > Is there a better way or utility. Is there a way to do it with HPL? I > think I've seen this somewhere before on this email list but I can't > find it. PeopleSoft by the way has over 5000+ tables. > > As always, your input and help is greatly appreciated. Thanks. > > Larry Panetta > DBA > panettal@mc-mc.com > 248-414-2224 > > Sent via Deja.com http://www.deja.com/ > Before you buy.