# Configuring whether Structural creates the destination database schema

By default, during each data generation job, Structural creates the database schema for the destination database tables, then populates the database tables based on the workspace configuration.

If you prefer to manage the destination database schema yourself, then set the [environment setting](https://docs.tonic.ai/app/admin/environment-variables-setting) `TONIC_ORACLE_SKIP_CREATE_DB` to `true`. You can add this setting manually to the **Environment Settings** list on **Structural Settings**.

You can override this setting manually in individual workspaces. For more information, go to [advanced-overrides](https://docs.tonic.ai/app/workspace/managing-workspaces/workspace-configuration-settings/advanced-overrides "mention").

## What happens when TONIC\_ORACLE\_SKIP\_CREATE\_DB is true? <a href="#oracle-skip-create-db-data-gen" id="oracle-skip-create-db-data-gen"></a>

When `TONIC_ORACLE_SKIP_CREATE_DB` is `true`, or the workspace overrides the setting to `true`, then Structural does not create the destination database schema. Before you run data generation, you must create the destination database with the full schema.

During data generation, Structural deletes the data from the destination database tables, except in the following cases:

* Tables that use Preserve Destination mode.
* Upsert data generation.

It then populates the tables with the new destination data.

For a diagram of the data generation process when you manage the destination schema, go to [#data-process-customer-schema](https://docs.tonic.ai/app/workflows/data-generation-run-job/data-generation-process#data-process-customer-schema "mention").

## Effect on required source and destination user privileges <a href="#oracle-skip-createdb-privilege-effect" id="oracle-skip-createdb-privilege-effect"></a>

For the source user, if Structural does not create the destination schema, then the source user must also have `EXECUTE ON` privileges for the `DBMS_METADATA` package.

The setting also affects the [required privileges for the destination user](https://docs.tonic.ai/app/setting-up-your-database/oracle/oracle-database-users/oracle-destination-user-create-config#required-destination-database-user-privileges).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tonic.ai/app/setting-up-your-database/oracle/oracle-before-workspace-creation/oracle-config-skip-db-creation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
