Learn Database Concepts

ORA-29516: Aurora assertion failure: Assertion failure From Oracle 11g release 1 (11.1), Oracle introduces just-in-time(JIT) compiler for Oracle JVM environment, which results in faster execution because invalidation, recompilation, and storage of code is done dynamically. JIT is controlled by parameter java_jit_enabled, and if it is set to TRUE then the Java methods are automatically compiled to native code by the JIT compiler and made available for use by all sessions. But you can get the error Ora-29516 Aurora assertion failure on Linux x64bit platform, and the workaround to overcome that error is turning off the JIT compiler: alter system set java_jit_enabled=false;

A profile is a named set of the following password and resource limits: a.. Password aging and expiration b.. Password history c.. Password complexity verification d.. Account locking e.. CPU time f.. Input/output (I/O) operations g.. Idle time h.. Connect time i.. Memory space (private SQL area for Shared Server only) j.. Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile of the user. The Oracle server automatically creates a DEFAULT profile when the database is created. The users who have not been explicitly assigned a specific profile conform to all the limits of the DEFAULT profile. All limits of the DEFAULT profile are initially unlimited. However, the database administrator can change the values so that limits are applied to all users by default. Profile usage: *********** a.. Restrict users from performing som...

  exporting schema excluding some tables: To exclude table from EXPDP Backup. Let's take a case, you have 100 tables in your schema and you want to export only 99 of them except two which are huge in size and already available at destination. Here, expdp   exclude=table:"in\('EMP'\,'DEPT'\)"   parameter is best for DBA . Make sure you provide table name in upper case, since values given are case sensitive.   expdp scott/***** directory=dpump schemas=scott dumpfile=scottdmp  logfile=scott.log exclude=table:"in\('emp'\,'emp_no'\)" Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 78.68 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing objec...

 exporting schema excluding some tables: To exclude table from EXPDP Backup. Let's take a case, you have 100 tables in your schema and you want to export only 99 of them except two which are huge in size and already available at destination. Here, expdp   exclude=table:"in\('EMP'\,'DEPT'\)"   parameter is best for DBA . Make sure you provide table name in upper case, since values given are case sensitive.   expdp scott/***** directory=dpump schemas=scott dumpfile=scottdmp  logfile=scott.log exclude=table:"in\('emp'\,'emp_no'\)" Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 78.68 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object...

When ever you try to insert an ambersand '&' into database, database tries to intract and get the values values from screen. in that case we can follow below steps create table test (name varchar2(35)); insert into test values ('hello&world'); I tried the escape character '\' but the system asks for a value of the substitution variable. Solution: set define off create table test (name varchar2(35)); insert into test values ('hello&world'); press 'F5' to execute the above commands.   (OR)     insert into table1 values('&'||'hello world'); 1 row created. select * from table1; COL1 -------------------------- &hello world