Technology Questions

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

Many times we would like to store information about the user locally in the computer. For example let’s say user has half-filled a long form and suddenly the internet connection breaks off. So the user would like you to store this information locally and when the internet comes back.He would like to get that information and send it to the server for storage.

Modern browsers have storage called as “Local storage” in which you can store this information.

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

In SQL, UNION  merges the contents of two structurally-compatible tables into a single combined table.

Some of the standard Business Intelligence tools in the market According to there performance 

1)MICROSTRATEGY 

2)BUSINESS OBJECTS,CRYSTAL REPORTS 

3)COGNOS REPORT NET 

4)MS-OLAP SERVICES

Business intelligence is a concept that covers development of warehousing and business intelligence applications and databases that assist in diagnosing and repairing user issues as well as performance ones. This is an extremely important set of procedures as it engenders quality end-user products and helps company representatives in understanding core issues and resolving them.

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.