Suppose if your database size is big or the size targeted data for the export is too high, you cannot accommodate the dump file in single file. Sometimes the OS will not allow you to create such big files.
EXPDP Filesize : Split or Slice the Dump file into Multiple / Different Directories and File Systems
Oracle Sequence Cycle vs Nocycle Difference and Comparison
The cycle option repeats the same set of sequence values once it reaches the max value. The next value will be reset to minimum value once it reaches the max value. The cycle option will end up with error if you are using this sequence for the primary key values as it won’t allow the duplicates.
Show Error Returns with No errors: How to find out PLSQL Compilation Errors?
Error Description
The PLSQL object created with compilation error. But SQLPLUS
show error returns ‘No errors.’
SQL> create force view VW_Force_Invalid
as select * from bonus;
Warning: View created with compilation errors.
SQL> show error
No errors.
How to find out the Size of the Oracle Database (Any Versions 10g, 11g)
Col DBFSizeGB for 99999.99
Col TMPFSizeGB for 99999.99
Col LOGFSizeMB for 99999.99
Col CTRLSizeGB for 99999.99
Col TotalSIzeGB for 99999.99
select DBFSizeGB, TMPFSizeGB, LOGFSizeMb, CTRLSizeMB,
DBFSizeGB+TMPFSizeGB+LOGFSizeMb/1024+CTRLSizeMB/1024 TotalSIzeGB
Oracle pfile vs spfile: Difference and Comparison
Pfile/Init file
1.
It is used for
database startup
2.
It is also called
INIT file
3.
It is a text file
which contains all the main parameters for the database startup
4.
This can be edited
using notepad or Vi editor
Oracle SQL, Function for finding out Age from DOB
PLSQL
Script for Function
create or replace function dob (birth char) return char as
x date;
age varchar2(30);
begin
select
to_date(birth,'ddmmyyyy') into x from dual;
select
trunc(months_between(sysdate, x)/12) ||' Years '||
trunc(mod(months_between(sysdate, x),12)) ||' Months '||
trunc(sysdate-add_months(x, trunc(months_between(sysdate, x)/12)*12+trunc(mod(months_between(sysdate,x),12))))||
' Days ' into age
from dual;
return age;
exception
Create or Alter User failed: ORA-00600: internal error code, arguments: [kzsviver:4]
Error Description
Create user command
failed with following error.
SQL> CREATE USER "ST" IDENTIFIED BY
VALUES 'S:E285C80B22886275424125E6A479E3B9CA84
F5FE51932DE4EF028DEA2CBF;D766CF03D5031EDC' ;
CREATE USER "ST" IDENTIFIED BY
VALUES 'S:E285C80B22886275424125E6A479E3B9CA84
*
ERROR
at line 1:
