To manage files in tablespaces :

  1. Click Setup in the Start Database window.

  2. Click the User Files tab in the Start Database Advanced Settings window.

  3. To create a user-defined file click the New button on the bottom of the user files field. A dialog box appears displaying the name of the database:

  4. Enter the logical file name in the Logical file name field (this is the path referenced by SQL commands and by DBMaker to reference your data).

  5. Enter a Physical File Name by entering a new path into the Physical File Name field, or by clicking on the browse button next to the Physical File Name field. This is the operating system path. The maximum number of characters for the Physical File Name path is 79.

  6. Enter a Page Size into the Page size combo box. This indicates the number of data pages allocated for the User-Defined File. The range of values for page size is 2 to 524,287.

  7. Click OK.

  8. A new user defined file will appear in the User Files field. The logical file name, physical file name, and page size can be changed after the user-defined file has been created. Double clicking on the text allows the user to edit it. This is useful if data files are moved within the operating system. DBMaker will not recognize a change in the physical file name unless it is specified here.

  9. To delete a user-defined file click Remove. DBMaker will no longer recognize the logical file name.

  10. Click Save.

  11. Click Cancel to return to the Create Database window, and click Start to start the database.


Related Topics:

User Files
User Files