Tablespace Creation
Author: Nedko Hristov
NOTE: All examples are done with Oracle 10g Enterprise Manager and therefore your particular settings while similar might slightly differ from the ones shown below. Oracle 9i works as well but instructions are not given here. Necessary Oracle administrative privileges are also required.
Tablespace Creation
You will need to create a tablespace called CASCADE where all Cascade Server tables will reside. The data import (described later) will create a user called CASCADE and the CASCADE schema. Here are the steps:
-
With Enterprise Manager opened to the desired database, go to "TABLESPACES" and click "Create".
-
Fill in "CASCADE" in the Name field and then under "Datafiles" click the "Add" button (Alternately you can avoid adding a datafile by checking "Use bigfile tablespace" check box, but we strongly recommend creating a separate file.)
-
While at the Add Datafile screen fill in "CASCADE.DBF" and point the File Directory to the desired location. Under File Size type 30 MB
-
Under storage check "Automatically extend datafile when full (AUTOEXTEND)" check box and in the "Increment" field fill 2 MB. Click "Continue."
-
Click "OK" to create the tablespace. The generated SQL should look like this:
You can also execute the above code in Sql*Plus to accomplish the same result. When finished with the tablespace creation, we can continue with the data import.