You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for datafile


1 to 20 of 1276 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database Administrator's Guide, 11g Release 1 (11.1)

Changing Datafile Size

Changing Datafile SizeThis section describes the various ways to alter the size of a datafile, and contains the following … topics: Enabling and Disabling Automatic Extension for a Datafile Manually Resizing a Datafile

Database Administrator's Guide, 11g Release 1 (11.1)

Changing Datafile Size

Enabling and Disabling Automatic Extension for a Datafilehalt or be suspended because of failures to allocate extents To determine whether a datafile is auto … enable or disable automatic file extension for existing datafiles, or manually resize a datafile, using … using the ALTER TABLESPACE statement. The following example enables automatic extension for a datafile … added to the users

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Datafile Availability

Bringing Datafiles Online or Taking Offline in ARCHIVELOG ModeTo bring an individual datafile online, issue the ALTER DATABASE statement and include the DATAFILE … clause.The following statement brings the specified datafile online: ALTER DATABASE DATAFILE '/u02 … : ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' OFFLINE; Note: To use this form of the ALTER

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Datafile Availability

Taking Datafiles Offline in NOARCHIVELOG ModeTo take a datafile offline when the database is in NOARCHIVELOG mode, use the ALTER DATABASE … statement with both the DATAFILE and OFFLINE FOR DROP clauses. The OFFLINE keyword causes the database to … mark the datafile OFFLINE, whether or not it is corrupted, so that you can open the database. The … FOR DROP keywords mark the

Database Administrator's Guide, 11g Release 1 (11.1)

Changing Datafile Size

Manually Resizing a DatafileYou can manually increase or decrease the size of a datafile using the ALTER DATABASE statement … bigfile tablespace you can use the ALTER TABLESPACE statement to resize a datafile. You are not … allowed to add a datafile to a bigfile tablespace. Manually reducing the sizes of datafiles enables you … requirements. In the next

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Datafile Availability

Altering the Availability of All Datafiles or Tempfiles in a Tablespace/offline status are: ALTER TABLESPACE... DATAFILE { ONLINE | OFFLINE } ALTER TABLESPACE... TEMPFILE … . The ALTER DATABASE DATAFILE and ALTER DATABASE TEMPFILE statements also have ONLINE/OFFLINE

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Datafile Availability

Altering Datafile Availabilityare brought back online. Reasons for altering datafile availability include the following: You want … to perform an offline backup of a datafile. You want to rename or relocate a datafile. You must … first take it offline or take the tablespace offline. The database has problems writing to a datafile … and automatically

Database Reference, 11g Release 1 (11.1)

V$DATAFILE

V$DATAFILEdisplays datafile information from the control file. See Also: \"V$DATAFILE_HEADER\", which … displays information from datafile headers Column Datatype Description FILE# NUMBER File identification … number CREATION_CHANGE# NUMBER Change number at which the datafile was created CREATION_TIME DATE … Timestamp of the datafile

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Transporting Data Across Platforms

Using CONVERT DATAFILE to Convert Datafile FormatsThis section explains how to use CONVERT DATAFILE. The section assumes that you intend to transport … perform cross-platform datafile conversion on the destination host: Start SQL*Plus and connect to the … command: % rman RMAN> CONNECT TARGET SYS@prod_dest Execute the CONVERT DATAFILE command to convert the … clause. RMAN> CONVERT

Database Concepts, 11g Release 1 (11.1)

Tablespaces, Datafiles, and Control Files

Datafile ContentsWhen a datafile is first created, the allocated disk space is formatted but does not contain any … datafile; rather, a datafile is a repository for the data of any schema object within a specific … users cannot control which datafile stores a schema object. See Also: Chapter 2, \"Data Blocks

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Command-Line Reference

DATA (datafile)datafile containing the data to be loaded. If you do not specify a file extension or file type, the … default is. dat. If you specify a datafile on the command line and also specify datafiles in the … control file with INFILE, the data specified on the command line is processed first. The first datafile

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Making User-Managed Database Backups

Verifying User-Managed Datafile Backupsthe database with VSS-enabled applications Verifying User-Managed Datafile Backups

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Configuring the RMAN Environment: Advanced Topics

Configuring Auxiliary Instance Datafile Namesidentifies some datafile by its original name or datafile number, and filename is the new path for the … new auxiliary name for datafile 2 as follows: CONFIGURE AUXNAME FOR DATAFILE 2 TO '/newdisk/datafiles … cleared with CONFIGURE... CLEAR, as shown in the following example: CONFIGURE AUXNAME FOR DATAFILE

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Oracle-Managed Files

Specifying the Undo Tablespace Datafile at Database CreationThe DATAFILE subclause of the UNDO TABLESPACE clause is optional and a filename is not required in … , then an Oracle-managed datafile is created in the DB_CREATE_FILE_DEST directory. If … datafile that is autoextensible is allocated as follows: If DB_CREATE_FILE_DEST is set, then an Oracle … -managed datafile

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Making User-Managed Database Backups

Testing the Restore of Datafile BackupsYou should periodically verify your backups to ensure that they are usable for recovery. Testing the Restore of Datafile Backups

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Validating Database Files and Backups

Parallelizing the Validation of a DatafileIf you need to validate a large datafile, then RMAN can parallelize the work by dividing the file … 256 sections. To parallelize the validation of a datafile: Start RMAN and connect to a target database … following example allocates two channels and validates a large datafile. The section size is 1200 MB … . RUN { ALLOCATE CHANNEL

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Making User-Managed Database Backups

Determining Datafile Status for Online Tablespace BackupsTo check whether a datafile is part of a current online tablespace backup, query the V$BACKUP view … AS \"DF_NAME\", b.status FROM V$DATAFILE d, V$TABLESPACE t, V$BACKUP b WHERE d.TS#=t.TS# AND b.FILE

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

Datafile Character SetsBy default, the datafile is in the character set defined by the NLS_LANG parameter. The datafile … *Loader supports all Oracle-supported character sets in the datafile (even those not supported as … as AL16UTF16 and JA16EUCFIXED) in the datafile. SQL*Loader also supports UTF-16 encoding with little … set. The

Database Concepts, 11g Release 1 (11.1)

Glossary

datafile… The datafiles contain the database data. A datafile can belong to only one database, and is located

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Control File Reference

Specifying Datafile Format and BufferingWhen configuring SQL*Loader, you can specify an operating system-dependent file processing options string ( os_file_proc_clause ) in the control file to specify file format and buffering. For example, suppose that your operating system has the following option-string syntax: Description of the illustration recsize_spec.gif In this syntax, RECSIZE is the size of a fixed-length record, and BUFFERS is