data file

To recover a loss datafile that belongs to READ-ONLY tablespace is an easy task indeed.

A URL is specified for the DataFile property; however, the XmlDataSource control does not have the correct permissions for the Web resource.

Saves the XML data currently held in memory by the XmlDataSource control to disk if the DataFile property is set.

Access is denied to the path specified for the DataFile property.

Since READ-ONLY tablespace is never modified, simply restore the datafile to its original location shall do the job.

Copy the corrupted or lost datafile from backup to the original location.

This example loads all the data from the datafile 'mydata', so no filters are defined.

XML data was loaded using the Data property instead of the DataFile property.

Similarly, you can also specify a comments character other than # with set datafile commentschar.

The example uses the dataFile. Xml file as input.

This section contains the following topics: Complete Recovery Incomplete Recovery Datafile Media Recovery Block Media Recovery

Recovering from the loss of a datafile that belongs to a temporary tablespace

Recovering from the loss of a datafile that belongs to a readonly tablespace

alter datafile backup controlfile to trace;