NO

The control files and the pfile are not concerned by the export/import.

In order to restore from a dump to another database, you need to create the same logical structure (Tablespaces) but not necessary the same physical structure (Datafiles) who are concerned by the control file. For the pfile, you can read the parameters and apply the one you need in the other but not all (Path are different for 2 different database, if on the same server, name must be different,...etc but open_cursor, shared_memory,...could be the same)


Degand Xavier
----- Original Message -----
From: "Fathy Neveen " <oracledba-ezmlmshield-x49550541.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: restore from export dump file for the whole database
Date: Wed, 4 May 2005 11:54:12 +0200

>
> When I am importing a dump file for a whole database to another new
> database does that include the control file and pfile or do I have to
> start upon mount after copying pfile by myself to it 's location and
> point to using
> Startup no mount pfile= 'pathname'
> Copy the control file
> Then recover until cancel
> Open the database
>
>
> OR the importing do all of this
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page