| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Full Ex/Im-port to New Instance, NT
On Fri, 9 Oct 1998 07:24:41 +0100, "Yassir Khogaly"
<yassir_at_khogaly.freeserve.co.uk> wrote:
>Hi,
>
>Yes.. I Said that and it is correct.
>Read the original emai you will find that the question was about Full import
>into an new Instance...! Talking about new instances..., Please try out this
>yourself :
>
>1)-FULLY EXPORT YOUR CURRENT DATABASE.
>2)-DROP YOUR DATABASE COMPLETELY & REMOVE THE DATAFILES physically and also
>remove Oracleservice & OracleStart services
>3)-RECREATE YOUR DATABASE WITH ALL EXACT PARAMETERS, Tablespaces, Datafiles
>Names & locations, BUT CHANGED DB_BLOCK_SIZE TO 8K from 2K which is the
>default for NT4.0.
>4)-TRY TO IMPORT YOUR PREVIOUS EXPORT now...?.
>
>Please Let me know if you still NOT happy...!
I'v done this many times before, with exactly the same situation you are describing - *new* instance with *changed* db_block_size, and never had any problems with full exp/imp. Never a single role, user, synonym etc was missing.
Only to convince myself again I just now did all 4 steps you listed above on my test machine and after the import new database was exact replica of the old one, except for the changed db_block size. All users, roles, synonyms etc were there, no problems.
So try it yourself and if you'll find any missing thing in your new database, send a more detailed description of the problem so we can find the error in your full_exp->new_db->full_imp procedure together.
Regards,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
 |
 |