Procedure or Function in Oracle is important to backup, because if you do not have a backup file, when the database is corrupted then the procedure will be lost. To back up the file we need SQL Developer Tools. Step by step until finish :
1. Open your application SQL Developer , choose schema will be backup and select menu Tools > Database Export.
In Oracle database if you find message => JBO-28030: Could not insert row into table PS_TXN, please fix error with :
Last Sequence :
CREATE SEQUENCE PS_TXN_SEQ MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
For good performance in oracle need tunning your database. Can use Gather your schema database for the example :
Gather Schema :
OwnName => 'DIARYCODING_DB'
,Granularity => 'DEFAULT'
,Options => 'GATHER'
,Gather_Temp => FALSE
,Estimate_Percent => 0
,Degree => 4
,Cascade => FALSE
,No_Invalidate => FALSE);