Use this dialog to remove the Connect CDC metabase from this server. The Connect CDC Director sends SQL to the sending server host machine to remove the RPUSER schema.
Before you remove the metabase, you should disable capture for any tables with change capture enabled. Failure to do so leaves Connect CDC triggers in place, which may interfere with user updates of your data tables. You have to remove these triggers yourself. If your tables still have capture enabled when you invoke the Remove Metabase program, the program offers to disable capture on the tables for you.
To remove the metabase
-
Select Remove Metabase from the context menu of your Teradata source.
-
Enter the database administrator password.
-
Review the text displayed in the Remove Metabase dialog.
-
Click OK to remove the metabase.
An output window displays a log of the SQL statements sent and any errors that occur. You can save or print this log, and you can copy selected text from it to the Windows Clipboard.
Upon successful removal, a confirmation message displays.
What happens
-
If the replication user and metabase schema name are the same, all traces of the metabase are removed, including the tables, database and the user.
-
If the replication user and the metabase schema name are different:
-
The metabase is removed.
-
If no other metabases exist under the user, the user is removed.
-
If the user owns other metabases, the user remains untouched.