Using SQLPlus under Linux Using SQLPlus under Linux You would be surprised to see that you can't rollback your command with the up arrow (last command entered)... Nov 15, 2009Programming > Databases > Oracle |
Display limit of Serveroutput Display limit of Serveroutput Serveroutput has a display limit which is set by default to a total of 1000 records but can be modified... Nov 13, 2009Programming > Databases > Oracle |
[Oracle] Making use of special characters [Oracle] Making use of special characters Intro Solution Intro For some SQL queries, we need to search for strings containing special... Nov 3, 2009Programming > Databases > Oracle |
[Oracle] Optimize import/export processes [Oracle] Optimize import/export processes Optimizing the performance of the Import/Export Make use of "commit = y" Adjust the buffer... Nov 3, 2009Programming > Databases > Oracle |
[Linux]Installing Oracle 11g on Ubuntu [Linux]Installing Oracle 11g on Ubuntu Intro Download UBUNTU Download Oracle X server configuration Updating packages Installing of... Oct 20, 2009Programming > Databases > Oracle |
[Oracle] Recover lost passwords [Oracle] Recover lost passwords To recover a password in Oracle, simply connect under command line mode on the server: #sqlplus /nolog... Oct 20, 2009Programming > Databases > Oracle |
[Oracle] Information about the size of the database [Oracle] Information about the size of the database Normally the size of the database is denoted by total size of the physical... Jul 31, 2009Programming > Databases > Oracle |
[Oracle] Backup Methodologies [Oracle] Backup Methodologies Intro Archive Logging Intro The system backup with NT or UNIX (such as dump or tar) should be performed... Jul 31, 2009Programming > Databases > Oracle |
Connecting to Oracle via php Connecting to Oracle via php Settings Requirements Example of code Settings Below is an article based on an example of connection to an... Jul 30, 2009Programming > Databases > Oracle |
[Oracle] Components of the Oracle architecture [Oracle] Components of the Oracle architecture The user process Process Servers Oracle database The Oracle server is the system that... Jul 19, 2009Programming > Databases > Oracle |
[Oracle] The lifecycle of a cursor [Oracle] The lifecycle of a cursor A good knowledge of the life cycle and the functioning of cursors will allow you to optimize... Jul 9, 2009Programming > Databases > Oracle |
[Oracle]Optimizing sorting operations [Oracle]Optimizing sorting operations You may certainly have noticed that when performing a sorting operation, there is an increase of... Jul 9, 2009Programming > Databases > Oracle |
Display Oracle parameters Display Oracle parameters In addition to the file init.ora, it is possible for you to consult the database to be check out parameters... Jul 3, 2009Programming > Databases > Oracle |
Display name of the Oracle database Display name of the Oracle database To view the name of the Oracle databases and data related to them, simply run the command: SELECT *... Jul 3, 2009Programming > Databases > Oracle |
Detecting objects that needs defragmentation due MAXEXTENT Detecting objects that needs defragmentation due MAXEXTENT To detect objects requiring defragmentation because of an overflow due to... Jul 3, 2009Programming > Databases > Oracle |
Creating a listener in the Oracle server Creating a listener in the Oracle server inorder to create a listener at a database server Oracle simply edit the listener.ora... Jul 2, 2009Programming > Databases > Oracle |
Backing up the database managed by the user Backing up the database managed by the user 1. Query views for information on database files Use the view V$DATAFILE to obtain a list... Jul 2, 2009Programming > Databases > Oracle |
Managing SQL parameters Managing SQL parameters SQL has a number of parameters at Oracle level that can be viewed it through the command: SHOW ALL To change... Jul 2, 2009Programming > Databases > Oracle |
Resetting a sequence Resetting a sequence To reset a sequence SEQ created through the command: CREATE SEQUENCE seq; Search for its current value via the... Jul 2, 2009Programming > Databases > Oracle |
ORA-01630 : max # extents (extent) reached in temp segment ORA-01630 : max # extents (extent) reached in temp segment ORA-01630 : max # extents (extent) reached in temp segment in tablespace... Jul 1, 2009Programming > Databases > Oracle |
