Steps to develop Oracle MIS system for Beginners

The difference between Oracle and SQL Server development is that developing a database application with SQL Server typically builds a database and then designs a database object in the database, such as tables/views/stored procedures/functions /diagram/users ... While Oracle is developing an application, it is common to create a database object, followed by the following steps:

1. Create a user's permanent tablespace and temporary tablespace (the corresponding data file will be created when the table space is established)

2. Establish the user and set the user's default tablespace

Create user TX identified by first default tablespace TX temporary tablespace tx_tmp;

3. Set user permissions on a tablespace

Alter user TX quota unlimited on TX;

Alter user TX quota unlimited on tx_tmp;

4. Set permissions for users

such as: Grant Connect, resource, create TABLE, create view to TX;

Remark:it Essays, if reproduced please indicate the source, thank you!

Author:terryxia

Steps to develop Oracle MIS system for Beginners