|
(→Data Pumping Export & Import)
|
(→Creation SQL)
|
| Line 31: | |||
| This section lists common SQL tasks that pertain to creating records or creating tables. | This section lists common SQL tasks that pertain to creating records or creating tables. | ||
| + | == Create a Tablespace == | ||
| + | This will create a new tablespace for Oracle. An example would be for anthillpro imports that rely on multiple tablespaces, you could remap them to this one. | ||
| + | <pre>CREATE TABLESPACE import DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\IMPORT.DBF' size 2047M;</pre> | ||
| === Initial User Creation === | === Initial User Creation === | ||
| Line 37: | |||
| grant connect, resource, create session, create table to testuser; | grant connect, resource, create session, create table to testuser; | ||
| </pre> | </pre> | ||
| == Deletion SQL == | == Deletion SQL == | ||
| This section lists common SQL tasks that deal with deleting/dropping information out of the database. | This section lists common SQL tasks that deal with deleting/dropping information out of the database. | ||
