rs_drop_repdef

(Oracle and Microsoft SQL Server only) A replication definition at the configured Replication Server for a table and procedure is dropped.

Note: This command is available only for Oracle and Microsoft SQL Server.

Syntax

rs_drop_repdef name

Parameters

name – A replication definition is dropped for that table or procedure.

Usage

When rs_drop_repdef is invoked, a replication definition for that table is dropped at Replication Server.
When rs_drop_repdef is invoked and the name of a table or procedure that is marked for replication is entered, a replication definition is created for that table or procedure.
For each table or procedure for which a replication definition is dropped, a result set is returned. The result set contains the table name and status of the create. If the replication definition was created, the status will be “dropped.” If an error occurred, an error message from Replication Server will be returned.
The character case of the object names in the replication definition will be set according to the ltl_character_case setting.
The following applies to replication definition table and procedure names:
- All non-alphanumeric characters and spaces are removed and are not part of the table or procedure name.
- Underscores are kept as part of the name even though they are non-alphanumeric characters.
- Periods are replaced with underscores.
Replication definition names for tables always begin with the prefix “ra$,” followed by a unique alphanumeric identifier (maximum of 8 characters), and ending with a table or object name. For example, for a replicate name of “My Table,” the resulting replication definition name is “ra$0x7952_mytable.” For an especially long replicate name of “mytable89012345678901234567890” (30 characters), the resulting replication definition name is “ra$0x7952_mytable8901234567890” (30 or 255 characters maximum, depending on whether or not the pdb_support_large_identifier configuration parameter is set).