How to get tablespace quota details of an user in oracle

This script reports the tablespace quota allocated for each database user and the amount of tablespace consumed by that user. TABLESPACE QUOTA DETAILS OF ALL THE USERS: [crayon-5beb1660dffca578552316/...

ORA-30041: Cannot grant quota on the tablespace

PROBLEM: Granting tablespace quota to a user is failing with ORA-30041. [crayon-5beb1660e2db5070900239/] SOLUTION: We can’t grant quota on a UNDO or TEMPORARY tablespace. Quota can be granted on...

Tablespace Management in oracle

What is a tablespace and datafile: Tablespace is the primary logic structure of the oracle database. It consists of one or more physical datafiles. Datafiles physical stores database data in storage.(...

How to get ddl of all tablespaces in oracle

 Below script will generate the DDLs of all the tablespaces in oracle. [crayon-5beb1660e51e8146213610/]

Query to check tablespace free space

Use below query to check all the space related details of tablespaces.   [crayon-5beb1660e54f0450006123/]

Skip to toolbar