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 844 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

V$DATAFILE

7.138 V$DATAFILEV$DATAFILE displays datafile information from the control file. See Also: \" V$DATAFILE_HEADER

Database 2 Day DBA, 12c Release 1 (12.1)

Setting the Datafile for a Smallfile Tablespace to Automatically Extend

6.3.2.2 Setting the Datafile for a Smallfile Tablespace to Automatically ExtendYou can use Oracle Enterprise Manager Database Express (EM Express) to set a datafile for a … assume that the datafile was previously not an autoextending datafile. To set a datafile to … . For a smallfile tablespace, select a datafile for which you want to enable autoextend, and then from … the

Database Administrator's Guide, 12c Release 1 (12.1)

Using Oracle Managed Files

The DATAFILE or SYSAUX DATAFILE clause is not required in the CREATE DATABASE statement, and omitting…Files: CREATE TABLESPACE, CREATE UNDO TABLESPACE, and ALTER TABLESPACE... ADD DATAFILE. The … ... ADD DATAFILE When creating a tablespace, either a permanent tablespace or an undo tablespace, the … DATAFILE clause is optional. When you include the DATAFILE clause, the file name is optional. If the … DATAFILE

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Transporting Data Across Platforms

Performing Tablespace Transportation on the Destination Host Using RMAN CONVERT DATAFILEThis section explains how to use the CONVERT DATAFILE command. The section assumes that you intend … : % rman RMAN> CONNECT TARGET \"sbu@prod_dest AS SYSBACKUP\"; Execute the CONVERT DATAFILE command to … PLATFORM clause. RMAN> CONVERT DATAFILE 2> '/tmp/transport_solaris/fin/fin01.dbf', 3> '/tmp

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Moving Data Files Between Disk Groups With ALTER DATABASE

Moving Data Files Between Disk Groups With ALTER DATABASEYou can use the ALTER DATABASE MOVE DATAFILE SQL statement to move data files between disk groups … Administrator's Guide for more information about using the ALTER DATABASE MOVE DATAFILE SQL statement to move … DATABASE MOVE DATAFILE /* Create a new disk group DATA2 using ASMCA, ASMCMD, or SQL */ /* Then create … '; ALTER DISKGROUP

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Using File Mapping Views With Oracle ASM Files

Using File Mapping Views With Oracle ASM Files------------ --------------------------------------------- ----------- --------- 0 +DATA/ORCL/DATAFILE/system.258.841314095 DATAFILE … ASMFILE 1 +DATA/ORCL/DATAFILE/sysaux.257.841314021 DATAFILE ASMFILE 2 +DATA/ORCL/DATAFILE … /undotbs1.260.841314161 DATAFILE ASMFILE 3 +DATA/ORCL/DATAFILE/example.266.841314219

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Moving Data Files Between Oracle ASM Disk Groups Using RMAN

Moving Data Files Between Oracle ASM Disk Groups Using RMANDATABASE MOVE DATAFILE. SQL statement to move data files. For information about moving data files … online with ALTER DATABASE MOVE DATAFILE, refer to \" Moving Data Files Between Disk Groups With ALTER … Size(MB) Tablespace RB segs Datafile Name … ---- -------- -------------- ------- ------------------------ 1 740 SYSTEM ***

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

pwd

pwd-48 Using the ASMCMD pwd command ASMCMD [+data/orcl/datafile] > pwd +data/orcl/datafile

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Creating Control Files in Oracle ASM

Creating Control Files in Oracle ASM: Example 1BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '+DATA/orcl/datafile/system.256.685366089', '+DATA/orcl/datafile … /sysaux.257.685366089', '+DATA/orcl/datafile/undotbs1.258.685366091', '+DATA/orcl/datafile/users.259.685366091' CHARACTER SET WE8MSWIN1252;

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Creating Control Files in Oracle ASM

Creating Control Files in Oracle ASM: Example 2/onlinelog/group_3.259.685366215' ) SIZE 50M BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '+DATA/orcl … /datafile/system.256.685366089', '+DATA/orcl/datafile/sysaux.257.685366089', '+DATA/orcl/datafile … /undotbs1.258.685366091', '+DATA/orcl/datafile/users.259.685366091' CHARACTER SET WE8MSWIN1252;

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

mkalias

mkaliasqualified file name +data/orcl/DATAFILE/SYSAUX.257.721811945. Following the mkalias command, ls … /datafile] > mkalias SYSAUX.257.721811945 sysaux.f ASMCMD [+data/orcl/datafile] > ls --absolutepath … none => EXAMPLE.265.721812093 +DATA/ORCL/DATAFILE/sysaux.f => SYSAUX.257.721811945 none => SYSTEM

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

lsof

lsof/current.260.691577263 orcl orcl +data/orcl/datafile/example.265.691577295 orcl orcl +data/orcl/datafile … /sysaux.257.691577149 orcl orcl +data/orcl/datafile/system.256.691577149 orcl orcl +data/orcl … /datafile/undotbs1.258.691577151 orcl orcl +data/orcl/datafile/users.259.691577151 orcl orcl +data/orcl

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

cd

cd… Example 10-40 Using the ASMCMD cd command ASMCMD [+data/hr] > cd +data/orcl ASMCMD [+data/orcl] > cd DATAFILE ASMCMD [+data/orcl/DATAFILE] >cd..

Database Administrator's Guide, 12c Release 1 (12.1)

Using Oracle Managed Files

If you previously created a control file specifying RESETLOGS and either did not specify file names…', '/u02/oradata/SAMPLE/onlinelog/o1_mf_2_p02rcyg3_.log') SIZE 100M NORESETLOGS DATAFILE '/u01/oradata … /SAMPLE/datafile/o1_mf_system_xu34ybm2_.dbf' SIZE 100M, '/u01/oradata/SAMPLE/datafile … /o1_mf_sysaux_aawbmz51_.dbf' SIZE 100M, '/u01/oradata/SAMPLE/datafile/o1_mf_sys_undo_apqbmz51_.dbf' SIZE 100M … DB_CREATE_ONLINE_LOG_DEST_

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Absolute Path and Relative Path

Absolute Path and Relative Path/datafile/users.259.555341963 The following cd command uses an absolute path to the directory … /orcl/DATAFILE/undotbs1.272.557429239. ASMCMD [+] > cd +data ASMCMD [+data] > cd orcl/DATAFILE ASMCMD … [+data/orcl/DATAFILE] > ls EXAMPLE.269.555342243 SYSAUX.257.555341961 SYSTEM.256.555341961 … UNDOTBS1.258.555341963

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Data Files and Temp Files

14.4.2 Bringing Data Files Online or Taking Offline in ARCHIVELOG ModeDATABASE statement and include the DATAFILE clause. The following statement brings the specified data … file online: ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' ONLINE; To take the same file … offline, issue the following statement: ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.8.3 Altering a Bigfile TablespaceDATAFILE clause): With a bigfile tablespace, you can use the AUTOEXTEND clause outside of the ADD … DATAFILE clause. For example: ALTER TABLESPACE bigtbs AUTOEXTEND ON NEXT 20G; An error is raised if you specify an ADD DATAFILE clause for a bigfile tablespace.

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.5.4 Specify Data File Attributes for the SYSAUX TablespaceDATAFILE clause in the CREATE DATABASE statement. If you include a DATAFILE clause for the SYSTEM … tablespace, then you must specify the SYSAUX DATAFILE clause as well, or the CREATE DATABASE statement will

Database Administrator's Guide, 12c Release 1 (12.1)

Transporting Data

You should follow a set of guidelines when transferring the data files.: starting datafile conversion input datafile file number=00007 name=/u01/app/oracle/oradata/salesdb … /sales_101.dbf converted datafile=/tmp/data_D-SALESDB_I-1192614013_TS-SALES_1_FNO-7_03jru08s channel … ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Managing Alias Names for Oracle ASM File Names

Adding an Alias Name for an Oracle ASM File NameOracle ASM file name ALTER DISKGROUP data ADD ALIAS '+data/orcl/second.dbf' FOR '+data/orcl/datafile/mytable.342.123456789';