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...
The control file in oracle is a small binary file necessary for the database to start and operate successfully. Each control file is associated with only one oracle database. Before a database is opened, the control file in oracle is read to determine if the database is in a valid state...
If there are any rows returned, note each file number (the first column data returned) to use later. If there are rows returned in the query from v$backup, then this means that the database crashed while there was a database backup running. To get the database back online, we need to...
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...
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...
pg_tablespace_location(oid) function is used to check the path of PostgreSQL tablespace location on disk. Tablespace in postgres is the physical… Continue Reading → Alter Tablespace Add Datafile in Oracle October 27, 2023admin To overcome tablespace full issue, you need to add datafile to the...
In this post you'll find out: Why you get ORA-01450 errors Solutions Upgrade to Oracle Database 23ai Use smaller varchar2 limits Store the index with a larger block size Create a standard_hash function-based index Create a substr function-based index ...
pg_tablespace_location(oid) function is used to check the path of PostgreSQL tablespace location on disk. Tablespace in postgres is the physical… Continue Reading → Alter Tablespace Add Datafile in Oracle October 27, 2023admin To overcome tablespace full issue, you need to add datafile to the...
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; ...
can a deleted package in ssis be retrieved? Can an SSIS package be run/invoked multiple times while the previous invocation is still running? Can I create a SSIS package to get only row 12 to row 123 from an excel sheet..?? Can I have multiple instances of SSIS on a server? Can I...