TEMP /home/oracle/app/oracle/oradata/cdb1/orcl/orcl_temp01201 4-07-30_04-39-23-PM.dbf Create another Temporary Tablespace TEMP1 CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ‘/u01/app/oradata/DBACLASS/temp01′ SIZE 2G; Move Default Database temp tablespace ALTER DATABASE DEFAULT TEMPORARY TABL...
channel ch00: specifying datafile(s) in backupset input datafile fno=00005 name=/u02/oradata/db/example01.dbf input datafile fno=00011 name=/u02/oradata/db/test2.dbf input datafile fno=00009 name=/u02/oradata/db/users01.dbf input datafile fno=00004 name=/u02/oradata/db/drsys01.dbf ...
Direct path loads – creates data blocks in Oracle database block format from the datafile and directly writes the data block to the database. This way is much faster than the conventional path but subject to some restrictions. External table loads – create anexternal tablefor the data stored...
/* variable to spot space wastage in datafile of uniform tablespace */ space_wastage number; begin /* recyclebin is present in Oracle 10.2 and higher and might contain extent as checked */ begin select value into checkval from v$parameter where name = 'recyclebin'; if checkval = 'on' t...
Use SQL*Plus or your favorite SQL command line tool to log in to the target database; log in assysdba Type the following commands to get the path to various files: select name from v$datafile; select member from v$logfile; select name from v$controlfile; ...
SQL> create undo tablespace UNDOTBS2 datafile 'D:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\UNDOTBS02.DBF' size 5000M; 2. Switch to the new Undo tablespace: SQL> ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS2 SCOPE=BOTH; 3. Check the status of the undo segments and determine if all the segmen...
You can use alter tablespace command to extend tablespace in Oracle: SQL> alter tablespace RAIDDATA add datafile 'FILE_LOCATION' size 100m autoextend on maxsize 31G; Note: You can find file location from the 1st query as mentioned above. In case of ASM, use diskgroup name as a file loca...
[ Check outHow to Create TableSpaces in Oracle DBA?] 4. Startup the database Sql>startup; To obtain the location and name of the control files, you can use the following commands: Sql>select name from v$controlfile; Sql>select name,value from v$parameter wher name = ‘control_files’;...
ORA-01653: unable to extend table SYS.EYGLE by 128 in tablespace EYGLE SQL> alter database datafile '/opt/oracle/eygle01.dbf' resize 20m; Database altered. SQL> insert into eygle select * from eygle; 50420 rows created. SQL> commit; ...
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_testdb1.f'; # default Check the tablespace exist in databae SQL> select * from v$tablespace; TS# NAME INC BIG FLA ENC --- --- --- --- --- --- 0 SYSTEM YES NO YES 1 SYSAUX YES NO YES...