How to Get ddl of any Object in Oracle: In this article we will explain about How to Get ddl of any Object in Oracle using DBMS_METADATA.GET_DDL. Use of DBMS_METADATA: Every time all DBAs and Developers required to create scripts of objects like Tables, Indexes, Packages, Packages Body etc. In Oracle database has a package … Read more
How to Find Out the size of your Oracle Database : In this Article we are going to discuss about How to Find Out the size of your Oracle Database. Database Sizes : We can find out Database Total Size, Database Used Size, Database Free Size using below queries. Also you can use below mentioned … Read more
During this article we will discuss with you about a way to find the list of Character set of the Oracle database. Notes : Review characterset options before you begin installation. After a database creation is done then, changing its Character set is typically very expensive in terms of your time and resources. Such type … Read more
Generate user ddl in Oracle: In this article we will discuss about how to Generate user ddl in Oracle. You can use below scripts to generate DDL statements for a user or multiple users with their roles, system and object privileges. To generate ddl for a specified user: In this case we generate ddl for … Read more
How to generate tablespace ddl in Oracle: In this article we will see How to generate tablespace ddl in Oracle for one tablespace and all tablespaces. Generate one tablespace’s ddl By this below query you can generate tablespace ddl for a specified tablespace. After run this query it will ask you to provide the tablespace_name. … Read more
Tablespaces and Datafiles Status in Oracle: In this article we will discuss about How to check Tablespaces and Datafiles Status in Oracle. What is an Oracle Tablespace: Oracle divides a database into one or more logical storage units called tablespaces. Each tablespace consists of one or more files called datafiles. A datafile physically stores the … Read more
