Hi, Today I am getting the “ORA-12919: Can not drop the default permanent tablespace” error. Actually, I tried to drop users tablespace which is the default tablespace for the database user and I’m getting the above error. ORA-12919 Can not drop the default permanent tablespace Cause – We tried to …
Read moreORA-12919: Can not drop the default permanent tablespace
Hi, In this article we are going to learn how to export tablespaces using expdp data pump utility practically. What is tablespace? A tablespace is a logical unit of storage that is used by the database to store database objects like tables and PL/SQL codes. We can export tablespaces using …
Read moreHow To Export Tablespaces Using Expdp Data Pump Utility?
What is Character Functions Hello, friends in this article we are going to discuss how to use Character Functions in SQL. The character functions accept only Character type values and return in character and number both. Type of Character Functions There are Eight types of Character Functions in SQL. CONCAT …
Single row functions operate on a single row only then return one result each row, there are many types of single-row functions. Following are the types of Single Row Functions. Number Function. Date Function. Character Function. Conversion Function. General Function. Number Function Always accept only numeric values and also return always …
In this article we are going to learn how to create and use SEQUENCE. What is SEQUENCE? SEQUENCE is an oracle shareable object which is generated numeric values and it can be unique. you can use this value as a primary key and unique value. Let see how to create SEQUENCE and how to use sequence …
Hello friends, In this article, we are going to discuss, how to use the ALTER TABLE ORACLE MODIFY column. Using this command we can modify table structure if required after table creation. Alter Table Oracle Modify In this practical we are using following table which has three columns. Modify Column …
Hello friends, In this article we are going to find cpu and memory information of oracle database server. The below script will help us to get CPU, memory and core, socket information of an Oracle database server from SQL prompt. Output from above query. Read: How To Find Execution History …
Read moreHow To Find CPU And Memory Information Of Oracle Database Server
Hello friends, in this article I’m going to show you how to find execution history of an sql_id. The below script will display the execution history of a sql_id from AWR. It will join the dba_hist_sqlstat and dba_hist_sqlsnapshot table to get the required information. Read: ORA 25153 Temporary Tablespace is …
Here is the solution of ORA 25153. If you faced the above error just add more space in the temporary tablespace or add a new tempfile in the temporary tablespace. How to check temporary tablespace in oracle Check the temporary tablespace size using the below query. Or you can use …
In this article we are going to show you how to get tablespace quota details of an user in oracle. Using below query you can get the tablespace quota details of the user. Output from above query: HOW TO GET TABLESPACE QUOTA DETAILS FOR A PARTICULAR USER Using below query …
Read moreHow To Get Tablespace Quota Details Of An User In Oracle