Oracle DB Basis - Authentication and SQL LOADER

Authentication 

OS authentication

1. 設定方式: In parameter file, remote_login_passwordfile = none

Use a password file

remote_login_passwordfile = exclusive

1. 用orapwd程式，來建立password file
2. 如果是用dbca來建立database的，則系統會自動建立password file

SQL Loader

sqlldr system/second3@second3 control=first_tbl.ctl log=first_tbl.log

Segment Space Management

轉載自  http://www.dba-oracle.com/t_automatic_segment_space_management.htm

Automatic segment space management (ASSM, or bitmap freelists) is a simpler and more efficient way of managing space within a segment. It completely eliminates any need to specify and tune the pctused, freelists, and freelist groups storage parameters for schema objects created in the tablespace. If any of these attributes are specified, they are ignored.