New Oracle User/tablespace/increase Oracle SGA Memory

One is to add data files to the tablespace, and the following SQL statements are performed under the database administrator Sysman User: Create tablespace lzs  datafile ' d:\ORACLE\PRODUCT\10.2.0\ORADATA\ orcl\lzs.dbf ' size 2048m;create tablespace lzs_doc  datafile ' d:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\lzs_doc.dbf ' Size 512M;

　　

Increase Oracle SGA Memory: (This step can be ignored) sql> alter system set Sga_garget = 800*1024*1024 scope = BOTH;    (/*800m*/)

　　

To establish the user, the default tablespace is users, the following SQL statements are performed under the database administrator Sysman user; CREATE user "LZS" identified by "LZS" Default Tablespace "users"-- Temporary tablespace "TEMP" profile DEFAULT account UNLOCK; GRANT "CONNECT" to "LZS"; GRANT "RESOURCE" to "LZS"; GRANT UNLIMITED tablespace to "LZS"; ALTER USER "LZS" DEFAULT ROLE all; GRANT "DBA" to "LZS";

　　

New Oracle User/tablespace/increase Oracle SGA Memory