Re: New Server

I would make sure that you have your user accounts and tablespaces set up with the same names before you do your migration. That way you won't have all your tables and indexes in one tablespace--your default.

If you're moving from an Oracle 8 database, you need to use the exp73 utility for compatibility.

If you want to do this in manageable chunks, you might want to do your exports schema-by-schema. There's no sense in migrating SYS or SYSTEM, unless you've done some development in there (bad idea).

--Bob.

edjohnjr wrote in message ...
>You have helped me a great deal with your suggestions thus far and I want
to
>say Thanks.
>
>New situation for me. I have been given a dual processor, 256 meg, and 36
>gig server to install Oracle 7.3.4 NT 4.0. First, I want move the existing
>database from my development server to this new server as is. I know I
must
>install Oracle database server but do I make use of export/import
>procedures? Second, what would be my default size buffer for this given
>server? I am a NEWBIE. Third, could you suggest which path I should be
>following so this install and transfer procedure goes as smooth as
possible.
>
>Thanks,
>
>edjohnjr_at_cwix.com
>
>
>
Received on Sun Oct 25 1998 - 09:10:23 CST