Data Vault Administrator Guide

6.4.3 HotFix 1
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3

Back Next

Data Vault Cleanup

Use the ssacleanup utility to remove specified objects from the Data Vault, for example a database, schema, or table. You can also use ssacleanup to remove orphaned SCT files and SCT files assigned to a database that you also remove.

The ssacleanup utility uses the following syntax:

ssacleanup [ <flags> ]
[-h (displays the help screen)]
[-e (reports orphan SCT files from disk only)]
[-a (remove orphan SCT files from disk only)]
[-b<n> (time in hours to remove orphan files older than <n> hour)]
[-c (remove SCT files assigned for database for -d flag)]
[-d<name> (remove database)]
[-l<dir>[,<dir>] (SCT files path(s) for -a mode only. Multiple paths are separated by commas)]
[-m (skip shared metadata domain cleanup)]
[-r<dir> (temporary directory for log, report, and runtime files]
[-s<name> (remove schema)]
[-t<name> (remove table)]
[-u UID[/PWD] (Data Vault user name and password)]

You can specify the flags in any order. The following table describes the flags:

Option	Description
-h	Displays the help screen.
-e	Generates a report of the orphan SCT files. The report is generated in the current working directory from where ssacleanup is called. If you want to generate and review a report of orphaned SCT files before you remove them, use the -e flag.
-a	Removes orphaned files from disk only. You must specify the location of the files with the -l flag.
-b	Specifies the time in hours for which the command removes orphaned files older than the number of hours ( <n> ). By default, this value is .5 hours and all orphaned files created more than 30 minutes after running the utility will be deleted. Files that have been created within 30 minutes of running the utility are not deleted by default. This protects SCT files that were recently-created by a running archive loader job, but are not yet registered in the metadata catalog. You can change the default value to retain SCT files that were created within a certain time period.
-c	Removes SCT files assigned to a database object that you will remove by specifying a value for the -d flag. By default, all SCT files registered for removed database objects remain on disk. Once cleanup is finished, the files become orphan. Use the -c flag to remove the SCT files when you remove the object. Or, you can use the -a flag to remove orphaned files at a later time.
-d	Removes the specified database object.
-l	Specifies the location of orphaned SCT files that you want to remove. Files that are present in this location but not referenced in the metadata catalog are deleted when you specify the -a flag. Both the -a flag and -l flag are mandatory to remove orphaned files. You can specify multiple locations. Separate the file paths with a comma.
-m	Skips cleanup on the shared metadata domain.
-r	Location of the temporary directory for log, report, and run-time files. When you run the utility, it generates a log and a report in the temporary directory. The log file contains information about the functions that were successfully called and exited. Create this directory before you run the command. If you encounter an error, check the log files.
-s	Removes the specified schema.
-t	Removes the specified table. When you specify a value for -t<name> , you must also specify a value for the flags -d<name> and -s<name> .
-u	Required. Data Vault user name and password.

The Data Vault DBA user or owner of the database with granted privileges must run the ssacleanup utility. If a non-DBA user calls ssacleanup to remove objects that they do not own, the process fails with an authorization error.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Data Vault Cleanup

Data Vault Cleanup