Oracle Default user name and password

In front of a machine, I put all the software installed again, the development environment reconfiguration (VS2003, vs2008, Oracle ...), it is not easy, during the encounter a lot of problems, but it is easy to solve. However, in the Oracle installation, the creation of a database, the installation process also set the user name and password, but is not successful login, check to check is the user authorization problem, so also through the Oracle System Management user login to the previous user name authorization.

The default user name and password in Oracle is the following table:

　　

Some simple things to do:

Run-in input cmd-> input sqlplus

You will need to enter your user name and password to use the system

1. Create a temporary tablespace:

Create temporary tablespace test_temp

Tempfile '/oracle/product/10.2.0/oradata/test/test_temp01.dbf '//directory to be present

Size 32m

Autoextend on

Next 32m MaxSize 1024m

Extent management Local;

2. Create a data table space:

Create temporary tablespace test_data

Tempfile '/oracle/product/10.2.0/oradata/test/test_data01.dbf '//directory to be present

Size 32m

Autoextend on

Next 32m MaxSize 1024m

Extent management Local;

3. Create a user

Create user username identified by password

Default Tablespace test_data

Temporary tablespace test_temp;

4. Granting permissions to users

Grant Connect,resource,...... to user name;

5. Unlock the user

Alter user SYSTEM account unlock;

6. Delete a user

Drop user username cascade;

Original from the "Bit network", reproduced please keep the original link: http://soft.chinabyte.com/database/290/11378790.shtml

Oracle Default user name and password