Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: .ORA files -- can one import from them???

Re: .ORA files -- can one import from them???

From: Jean-Claude Matarazzo <jcmata_at_club-internet.fr>
Date: Thu, 28 Jan 1999 22:09:59 +0100
Message-ID: <36B0D226.187898E5@club-internet.fr>


The file pdl.ora is a part of your database. You can not use this file in another database, because
int the header off the file, you have informations stampped by the kernel (database name, Last Number of Modification 'SCN' (every modification on the database is identified) , dates, ...).
All the files off the database have the same header. The list of the files are stored in the control files (you see it in the INITsid.ORA file).

So, you have to startup your database or restore it.

Have you use the export utility of oracle (EXP.EXE ) to do backup. This utility generate his own file.
You can easily restore only one table if you want, or the full database. The import utility (IMP.EXE) read only the file generated by the export.

Sorry

>
Received on Thu Jan 28 1999 - 15:09:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US