ORACLE Build Process Summary

1, forget sys password

Open the CMD Command window and do the following:

1,sqlplus/nolog;2,3,connect/as sysdba4,5,alter User SYS identified by new password 6,7,alter user SYSTEM identified by new password 8,

The second method:

Rebuilding the password file requires rebuilding the password file in the following steps: 1. First, determine the path and name of your password file: Under Windows password file path oracle_home\database password file name pwd+ Sid.ora under Unix password file path oracle_home/dbs password file name pwd+sidsid instance name, view instance name select instance_name from V$instance;select ' pwd ' | | instance_name| | '. Ora ' from v$instance;2. Rename the original password file to Pwd+sid+back.ora at the Windows command prompt to rebuild the password file: Orapwd file= ..... password=. password file contains the SYS password for example: Orapwd File=f:\oracle\product\10.2.0\db_1\database\pwdorcl.ora password= 123 This establishes the SYS password to 123 and can log in.

2, log in with SYS account

Establish user table space, index tablespace, create user, authorize, assign quota:

--Create user table space--base zone create tablespace tablespace_name datafile  ' d:/oracledata/tablespace_name01.dbf ' SIZE 100M Autoextend on NEXT 10M MAXSIZE unlimited;--CREATE INDEX tablespace--base zone create tablespace tppaml_bse_idx datafile  ' d:/oracledata/ TABLESPACE_NAME_IDX01.DBF ' SIZE 100M autoextend on NEXT 10M MAXSIZE UNLIMITED;

--Create a temporary tablespace--base zone
Create temporary tablespace user_temp tempfile
  ' d:/oracledata/teblespace_name01_ods.dbf ' size 100M autoextend on next 10M maxsize 100M;

--Tppaml authorization to the user  

--debug Permissions
GRANT Debug any procedure, debug connect session to Username

--Create TABLE permissions in all table spaces (consider if necessary)





ALTER USER USERNAME QUOTA UNLIMITED on Tablespace_name;

3, use the new account login to build the table can

CREATE TABLE table_name (   ID             VARCHAR2 (+) not NULL,   NAME           VARCHAR2 (+)) tablespace Tablespace_name   PCTFREE Ten   Initrans  1   maxtrans  255   STORAGE   (      INITIAL   1M      NEXT      1M      minextents  1
      MAXEXTENTS  UNLIMITED       pctincrease  0   ); ALTER TABLE table_name   ADD CONSTRAINT primart_table  PRIMARY key (ID)  --foreign key   USING  INDEX   Tablespace  tablespace_name   PCTFREE   initrans  2   maxtrans 255   STORAGE   (      INITIAL  1M      NEXT     1M      minextents  1
      MAXEXTENTS  UNLIMITED       pctincrease  0   );

ORACLE Build Process Summary