| 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: moving datafiles
On Tue, 25 Feb 1997 09:21:09 -0600, muller.brenda_at_primestar.tci.com wrote:
>
>Thanks very much for your response, and to the others also. This does
>solve my immediate problem. However, I was hoping to get some
>information regarding where these datafile names are kept in the system
>DDL. I originally thought that they were only kept in the control files,
>but recently read something which led me to believe that it was possible
>to have your system DDL refer to a filename which wasn't in a control
>file. This would make me think that Oracle is storing these names
>internally as well as externally. Can anyone enlighten me?
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
When the database is down, the names exist in the control files.
when the database is 'up' and mounted, they exist in the control files and in some v$ tables (v$datafiles, v$log). v$ tables are memory tables and only exist while the database is 'up'.
You can get it in ascii as well by issuing
alter database backup controlfile to trace;
which will create a 'create controlfile' statement for your database (real handy to have one of these in case you lose all N of your controlfiles). You can edit the created control file by hand to change file names, shut down your database, rename your datafiles to match the 'create controlfile' statement, move your existing controlfiles somewhere else and running the generated create control file statement in svrmgrl as well.
The create controlfile statement above can also be modified to change the max datafiles in a database and max logfiles (since changing these makes it necessary to rewrite the controlfiles which are fixed in size based on the maximum number of files they will hold)...
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
 |
 |