Home

APPLSYSPUB schema

APPLSYSPUB  is the database schema. it is the first schema that is used in any connection in Oracle apps. APPLSYSPUB default password is PUB. It is not an application user and thus you cannot find that in the FND_USER table in the Oracle database of Oracle applications Oracle forms, and OACORE  all connect to it …

APPLSYSPUB schema Read More »

How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER

Introduction We often want to run pre-defined jobs at different schedules. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for scheduling pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs …

How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER Read More »

How to create tablespace in Oracle

We will be discussing Oracle create tablespace statement/oracle create tablespace 11g/12c/19c in detail in this post. I will through light on all the option on create tablespace statement.I would also be discussing  ,how to alter the tablespace to read-only, offline the tablespace,how to move tablespace to another location,drop the tablespace. Apart from that, how you …

How to create tablespace in Oracle Read More »

Scroll to Top