Shulou(Shulou.com)06/01 Report--

1. Forget the sys password

Open the CMD command window and do the following:

1the new password of SQLPLUS / NOLOG;2,3,CONNECT / AS SYSDBA4,5,ALTER USER SYS IDENTIFIED BY, 6 the new password of 6, 7, the new password of alter USER SYSTEM IDENTIFIED BY, 8

The second method:

To rebuild the password file, you need to rebuild the password file. The specific steps are as follows: 1. First, make sure the path and name of your password file: under windows, password file path oracle_home\ database password file name pwd+sid.ora, password file path oracle_home/dbs password file name pwd+sidSid is the instance name, check the instance name Select instance_name from vault instancet select 'pwd' | | instance_name | | .ora' from vandalism instancet2. Rename the original password file to pwd+sid+back.ora and rebuild the password file at the windows command prompt: Orapwd file=... .. Password=... . The password file contains the password of sys, for example: orapwd file=F:\ oracle\ product\ 10.2.0\ db_1\ database\ PWDorcl.ora password=123 so that the password of SYS is 123, you can log in.

2. Log in with your sys account

Create user tablespaces, index tablespaces, create users, authorize, assign quotas:

TABLESPACE TABLESPACE_NAME DATAFILE SIZE 100m AUTOEXTEND 10m MAXSIZE UNLIMITED; TABLESPACE TPPAML_BSE_IDX DATAFILE SIZE 100m AUTOEXTEND 10m MAXSIZE UNLIMITED;-- creates temporary tablespaces-- basic area create temporary tablespace user_temp tempfile'dVOG oracledata size TEBLESPACENAME01ODS.dbf' size 100m autoextend on next 10m maxsize 100M; USERNAME IDENTIFIED "USER_PASSWORD" TABLESPACE TABLESPACE_NAME; CONNECT USERNAME; RESOURCE USERNAME; USERNAME;--Debug permissions GRANT debug any procedure, debug connect session TO usernameGRANT CREATE ALL TABLE TO USERNAME

-- create table permissions under all tablespaces (consider whether it is required)

-- 1 System Privilege for username

GRANT UNLIMITED TABLESPACE TO USERNAME

-- 1 Tablespace Quota for username unlimited space limit

ALTER USER USERNAME QUOTA UNLIMITED ON TABLESPACE_NAME

3. Log in and create a table with the newly created account.

TABLE_NAME (ID (), NAME ()) TABLESPACE TABLESPACE_NAME PCTFREE INITRANS MAXTRANS STORAGE (INITIAL 1m 1m MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE); TABLE_NAME PRIMART_TABLE (ID) USING TABLESPACE TABLESPACE_NAME PCTFREE INITRANS MAXTRANS STORAGE (INITIAL 1m 1m MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.