Posts

Oracle User Creation and Management

Image
1) As a competent DBA, before creating a new user to check the following items: * Determine the object must be stored in the user table space; * Determine the quota for each table space; * Give the user the default table space and temporary table space; * Create a user; * The user system privileges and roles required to give users; 2) The following example creates a user:     create user infotech - -to create a user name for the infotech;     identified by infotech -- the user's password is infotech;     default tablespace APEX_SPACE -- the user's default table space is APEX_SPACE;     temporary tablespace temp --the user temporary table space is pioneer_temp;     quota 30m on APEX_SPACE --the user to use up to 30M in APEX_SPACE space;     quota 30m on users --the user in the users table space to use up to 30M of space;     password expire --the first time the user l...

View Linux Directory Free Space Commands

Image
df-hl view the disk space left df-h view of the partition size for each root path  du-sh [directory name] returns the size of the directory du-sm [folder] to return to the folder number of the total Mv

openSUSE Linux 11.4 Released with Downloads

Image
openSUSE Linux 11.4 has been released with downloads Links. openSUSE Linux 11.4 Main Goals. Make openSUSE the easiest for anyone to become available and the most widely used Linux distributions. Joint use of open source software to make openSUSE the world's most available Linux distributions and Linux newbies and experienced users of the desktop environment. Significantly simplify and open up its development and packaging processes to make openSUSE a provider of Linux developers and software platform of choice.  Release Notes: http://news.opensuse.org/2011/03/10/opensuse-11-4/ http://download.opensuse.org/distribution/11.4/iso/openSUSE-11.4-KDE-LiveCD-i686.iso http://download.opensuse.org/distribution/11.4/iso/openSUSE-11.4-GNOME-LiveCD-i686.iso http://download.opensuse.org/distribution/11.4/iso/openSUSE-11.4-KDE-LiveCD-x86_64.iso http://download.opensuse.org/distribution/11.4/iso/openSUSE-11.4-GNOME-LiveCD-x86_64.iso

Top 7 Open Source Linux Distribution in 2011

Image
1) Ubuntu Linux 2) Mandriva Linux 3) PCLinuxOS   4) Gentoo Linux 5) openSUSE Linux   6) Debian 7) FreeBSD

SUSE Linux 11 Wallpapers

Image
SUSE Linux Black SUSE Linux Green SUSE Linux Inspiration

Oracle Enterprise Linux Wallpapers

Image
Oracle Enterprise Linux Wallpapers

Creating Views in Oracle Database Using TOAD

Image
A view logically represents subsets of data from one or more tables. You can restrict a user’s access to data in a table by using views. A view does not have a structure of its own and is stored as a SELECT statement in the database. Views are of two types, simple and complex: • Simple view: Retrieves data from only one table and contains no functions or group data. You can  perform DML operations through a simple view. • Complex view: Retrieves data from multiple tables or contains functions or group data. A complex  view does not always allow you to perform DML operations. Creating Simple View You create a simple view based on only one table. In other words, the SELECT statement of the view  retrieves data from only one table. For example:- CREATE OR REPLACE VIEW EMP_VU (EMPNO, EMP_NAME, ANNUAL_SALARY, DEPTNO) AS SELECT e.EMPNO, e.EMP_NAME, e.SALARY*12, e.DEPTNO FROM employee e; Write the SQL script in SQL tab and press F5 to execute. ...