Continuing the Oracle Cheat Sheet 🙂
1. Create an Oracle user
create user xxx identified by yyy;
grant connect, resource, unlimited tablespace to xxx [identified by yyy];
grant create session to xxx;
2. Extend tablespace
ALTER DATABASE
DATAFILE 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF'
RESIZE 1000M;
3. Invoking UNIX commands from SQL*Plus
You can invoke a UNIX command from SQL*Plus by using “HOST COMMAND”:
host ls -la *.sql
lists all SQL files in the current directory
(more…)
- Likes (0)
- Comments (1)
-
Share