Re: Full export of data -> Restore

Does this mean that for instance by using the parameters DESTROY=Y, ROWS=N, INDEXFILE=myindexes.sql, I don't have to make ANY tablespaces or even datafiles in advance of importing the data?

My real life problem is that the whole disk where the control files and such lay has gone bananas, and we haven't really exercised this before (shame on us!). What I intend to do is just create an empty database and import yesterday's full export, but I'm not sure how much planning I should do in advance, with regards to making new datafiles and so on. There are plenty datafiles lying about that I want to overwrite if I can get away with not deleting them first. What about tables growing out of their tablespaces or even datafiles because of extent compression during export? Should I perhaps make some large files in advance just in case? I know there are some pretty big tables there, which might possibly span several existing datafiles.

On a side note: Would increasing DB_BLOCK_SIZE from 4096 to 8192 do my 15GB system any good, running on plain WinNT 4.0 NTFS drives? What would be a proper number for DB_BUFFER_SIZE, when the system is a web solution for approx. 2-300 concurrent users? What about PROCESSES? And OPEN_CURSORS for that matter. Now it has OPEN_CURSOR=700, but I once got a message stating there were too few. What about SORT_AREA_SIZE for that matter? Now, this is turning into a tuning question.....

In article <83qn0r$krn$1_at_nnrp1.deja.com>,   Ed Prochak <prochak_at_my-deja.com> wrote:
> In article <joV74.70$8m4.5494_at_news.uswest.net>,
> "W. Scott Moore" <sirws_at_hotmail.com> wrote:
> > I run a full export of my databases every night. What would I need
to
> do to
> > restore all of the data from an export file if I lost the datafiles.
> Can
> > you make it so when you import, that it creates/recreates the
> > datafiles/tablespaces and/or overwrites the existing ones?
> >
> > Thanks in advance,
> > Scott
> >
> >
>
> Yes the IMPORT command will restore the tables and other objects that
> were in the EXPORT. There are options to run the IMPORT which only
> creates the objects (and does not load the data). Really very
flexible.
>

---snip---
> --
> Ed Prochak
> Magic Interface, Ltd.
> ORACLE Development, conversions, training and support
> 440-498-3700 magic_at_interfacefamily.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 03 2000 - 14:32:06 CST