Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: .ORA files -- can one import from them???
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
![]() |
![]() |