DBA_TABLESPACES

How to Resolve ORA-00372: file cannot be modified at this time

by Ed Chen
February 2, 2023February 4, 2023

ORA-00372 Tried to update a table, but it failed with ORA-00372 and ORA-01110. SQL> show user USER is "HR" SQL> update employees set first_name =… Read More »

How Oracle Rename DataFile

by Ed Chen
October 18, 2022April 28, 2023

Rename DataFile The procedure of renaming an Oracle datafile is actually the same as the procedure of moving datafile with a different file name. Let's… Read More »

How to Resolve ORA-01542: tablespace is offline, cannot allocate space in it

by Ed Chen
July 29, 2022September 3, 2022

ORA-01542 Tried to move a table to another tablespace, but we got ORA-01542. SQL> alter table employees move tablespace users online; alter table employees move… Read More »

How to Check Tablespace Creation Date

by Ed Chen
May 30, 2022April 15, 2023

Tablespace Create Time There's no direct way to know the creation date of a tablespace, because either DBA_TABLESPACES or V$TABLESPACE doesn't have such information. But… Read More »

How to Resolve ORA-00959: tablespace does not exist

by Ed Chen
May 25, 2022March 20, 2023

ORA-00959 ORA-00959 means that the tablespace you specified in the statement cannot be found in the database, you should check the name you provide or… Read More »

What Tablespaces are Encrypted?

by Ed Chen
May 6, 2022May 11, 2023

Tablespace Level Encryption In this use case, DBA has done encryption infrastructure and create some encrypted tablespaces in the database. Now we would like to… Read More »

How to Resolve ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

by Ed Chen
October 29, 2021June 8, 2022

ORA-01219 Tried to query a data dictionary, but it failed with ORA-01219. SQL> select * from dba_tablespaces; select * from dba_tablespaces … Read More »

JavaScript is not enabled. Please enable it and reload the page.