First, access your TikTok for Business Marketing account and navigate to the analytics or reports section. TikTok provides options to export data directly from its dashboard. Look for the export option (usually available in CSV or Excel format) and download the necessary marketing data to your local system.

Once you have the data file, open it in a spreadsheet application like Microsoft Excel or Google Sheets. Clean and format the data as needed. Ensure that the columns match the structure of your Oracle Database tables. Remove any unnecessary columns or data that you do not wish to import. Save the cleaned data in a CSV format, which is easily importable into most databases.

Before importing, ensure your Oracle Database is properly set up and accessible. Confirm that you have the necessary permissions to create tables and insert data. You might need to collaborate with a database administrator to ensure you have the correct access rights and that the database is configured for data import.

Using SQL Developer or any other Oracle Database client, create the necessary table in your Oracle Database that matches the structure of your TikTok data. Define the appropriate data types for each column. Here's a basic example SQL statement to create a table:

```sql
CREATE TABLE tiktok_data (
id NUMBER PRIMARY KEY,
campaign_name VARCHAR2(255),
impressions NUMBER,
clicks NUMBER,
spend DECIMAL(10, 2),
date DATE
);
```

Adjust the table structure according to the specific attributes of your TikTok data.

Use Oracle's SQL*Loader utility to load the CSV data directly into your Oracle Database. SQL*Loader is a powerful tool that allows bulk data loading from text files. Create a control file (`control.ctl`) that defines how the CSV data should be loaded into the database table. Here’s a basic example of a control file content:

```
LOAD DATA
INFILE 'path_to_your_csv_file.csv'
INTO TABLE tiktok_data
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(id, campaign_name, impressions, clicks, spend, date "TO_DATE(:date, 'MM/DD/YYYY')")
```

Execute SQL*Loader from the command line:

```bash
sqlldr username/password@database control=control.ctl
```

After the import process, verify that the data has been correctly transferred. Run SQL queries to check the number of records, validate data types, and ensure no records have been lost or misformatted. For example:

```sql
SELECT COUNT(*) FROM tiktok_data;
SELECT * FROM tiktok_data WHERE ROWNUM <= 10;
```

This ensures that the data is intact and accurately reflects the source data from TikTok.

Consider creating scripts to automate the extraction, preparation, and import process for future data transfers. You can use shell scripts for running the SQL*Loader and other necessary commands, and schedule these using cron jobs or Windows Task Scheduler to automate the process at regular intervals. This step reduces manual effort and ensures a consistent data pipeline from TikTok to your Oracle Database.

By following these steps, you can effectively move data from TikTok for Business Marketing to your Oracle Database without relying on third-party connectors or integrations.