Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive logs....do they create data files
No !
You have to alter database create datafile ....to just create a datafile
with header info etc. Then apply the logs to the database to update the
changes to that data file, since the creation.
You will encounter this situation while maintaining a standby and a
primary database. You add a new file to the primary, you need to create the
datafile on the standby and then apply all archive files.
Neil Greene wrote in message ...
>
>Reading the Oracle documentation, it reads as if applying archive logs
>will also handle the creation of NEW datafiles as the physical schema of
>the database changes. Is this so??
>
>-----
>Neil Greene
>Cap Gemini America
>email: ngreene_at_usa.capgemini.com
>[remove NULL from posting address to reply]
Received on Sat Apr 11 1998 - 15:24:37 CDT