Oracle Database Commands

In Oracle unlike mysql, the database is represented by a schema owner.

A database schema is a logical container for data structures, called schema objects. Examples of schema objects are tables and indexes.

A database user has a password and particular database privileges assigned by the database admin.

In Oracle each user owns a single schema, which has the same name as the user. The schema contains the data for the user owning the schema. For example, the user "chamara" owns the schema "chamara" which contains schema objects such as tables in the database. In a production database, the schema owner usually represents a database application rather than a person.

Using the following commands u can create a schema in oracle database, which is a database you can used within your application.

Connect to the database as the db admin;

 sqlplus sys/admin as sysdba  

Drop user/schema if exists;

 drop user chamaraa cascade;

Create user/schema;

 create user chamaraa identified by chamaraa account unlock;

Grant connect permission;

 grant connect to chamaraa;

Grant other permisssions;

 grant create session,dba to chamaraa;

finally;

 commit;
 exit;

Connect to the created schema;

 sqlplus chamaraa/chamaraa@orcl

Running a script;

 SQL> @C:\path\oracle.sql;