Oracle Fast Build table space, user, empower

This article is not to give beginners a detailed explanation of how Oracle under the table space, user, empowerment and other command parameters and meaning, this article may only have a certain Oracle foundation of friends to help.

The Oracle database was also started in the recent project, and when the environment was set up, I found that my Oracle commands were almost forgotten, so I got some statements from the Internet: I can quickly build table space, users and empower, because my current project is not very rigorous, so like temporary table space, Details such as Oracle's permissions assignment are ignored here.

Since the beginning of the 10g, Oracle's console changed to a Web page form, not only the interface changes and relative speed is much slower, so I like to use the command line to operate the background.

1. Login to Oracle Sqlplus (both Windows and Linus apply)

Sqlplus/nolog

Connect SYSDBA as Sysdba

Show user; If successful, entering the command should return "SYS"

2. Building Table Space Statements

CREATE tablespace table space name datafile ' E:\oracle\product\10.1.0\oradata\ table space name. ORA ' size table space size autoextend on;

3. Create a user

Create user username identified by user password default tablespace tablespace name (temporary tablespace temporary tablespace name);

4. Empowering

Rant resource,connect,dba to user name; Assigning DBA authority to a user

5. Once you have configured Oracle NET manage, you can use the pl/SQL Developer Connection tool to access the table space you have just built.

Oracle Fast Build table space, user, empower