Saturday, October 16, 2010

Oracle how to create table space

Permanent tablespace

create tablespace ts_something   
logging   
datafile '/dbf1/ts_sth.dbf'    
size 32m    
autoextend on next 32m 
maxsize 2048m   
extent management local;

----
create tablespace data 
datafile '/home/oracle/databases/ora10/data.dbf' 
size 10M 
autoextend on 
maxsize 200M extent 
management local 
uniform size  64K; 

source::http://www.adp-gmbh.ch/ora/sql/create_tablespace.html

Centos 7 reset root/ any user lost password / lockout due to cant remember password

1. Need to be in front of the terminal. (Physically if not vm). 2. Reboot the server 3. Press 'e' in the GRUB2 boot screen. 3. bunch...