-
Title
How to create a tablespace and specify the hard drive and directory for the data file. -
Description
How to create a tablespace and specify the hard drive and directory for the datafile. -
Resolution
In Toad 8.6.1 or below:
NOTE: Please make sure you have the DBA module on your license key to perform the following actions:
1. Launch Toad and go through the menu DBA | Segment Management | Tablespaces. On this screen there is an icon for Create New Table Space. (This icon is also available at the Schema Browser window | Tablespaces tab | Create New Tablespace.)
2. Once the wizard starts, you can specify your tablespace name and other parameters.
3. Then click on the "Data Files" tab to specify the data file the table space is stored in.
4. Click the "Add" button will let you add a new data file.
5. In the field for "Datafile name" you can specify the directory relative to the database here. (For example, if you want the G: on the server then you would type something like G:MY_DATAFILE.DBF)
6. Click on OK when finished.
In Toad 9.0 or above:
NOTE: Please make sure you have the DBA module on your license key to perform the following actions:
1. Launch Toad and go through the menu Database | Create | Tablespace.
2. Once the wizard starts, you can specify your tablespace name and other parameters.
3. Then click on the "Data Files" tab to specify the data file the table space is stored in.
4. Click the "Add" button will let you add a new data file.
5. In the field for "Datafile name" you can specify the directory relative to the database here. (For example, if you want the G: on the server then you would type something like G:MY_DATAFILE.DBF)
6. Click on OK when finished.