DBA Catalog

Simple Solution

▼
Showing posts with label tablespace. Show all posts
Showing posts with label tablespace. Show all posts
Saturday, May 13, 2023

Oracle Database monitor tablespace script

›
With this script you can monitor tablespaces sizes in oracle database. This script returns next columns: Tablespace - tablespace name Size M...
Friday, November 17, 2017

ORA-01950: no privileges on tablespace in Oracle database 12c

›
Recently I faced error ORA-01950: no privileges on tablespace during import schema in oracle database 12c R2, which was exported from 11g R2...
Tuesday, January 21, 2014

ORA-55641: Cannot drop tablespace used by Flashback Data Archive

›
When I tried to drop tablespace appear next error: SQL> drop tablespace FLASHBACK_DATA_ARCHVIE including contents and datafiles; drop ta...
Wednesday, October 16, 2013

ORA-29857: domain indexes and/or secondary objects exist in the tablespace

›
While dropping a tablespace it fails with error ORA-29857 like below. SQL> drop tablespace example including contents and datafiles casc...
1 comment:
›
Home
View web version
Powered by Blogger.