< Back
Add-OracleDBLink
Post
NAME Add-OracleDBLink
SYNOPSIS
Add an Oracle Database Link.
SYNTAX
Add-OracleDBLink [-TargetDB] <String[]> [[-DBUser] <String>] [-PasswordPrompt] [-SchemaName] <String> [-LinkName]
<String> [-LinkUser] <String> [-LinkPasswordPrompt] [-LinkTarget] <String> [[-Parallelism] <Int32>]
[<CommonParameters>]
DESCRIPTION
This function adds an Oracle Database Link.
PARAMETERS
-TargetDB <String[]>
Target Database
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-DBUser <String>
Username if required
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-PasswordPrompt [<SwitchParameter>]
Flag to ask for a password
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-SchemaName <String>
Schema Name
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LinkName <String>
DB Link Name
Required? true
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LinkUser <String>
DB Link Username
Required? true
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LinkPasswordPrompt [<SwitchParameter>]
DB Link Password Promt flag
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-LinkTarget <String>
DB Link Host (Target database)
Required? true
Position? 6
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Parallelism <Int32>
Parallelism Degree
Required? false
Position? 7
Default value 1
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Add-OracleDBLink -TargetDB myorcl -SchemaName myuser -LinkName myDBLink -LinkUser myRemoteUser
-LinkPasswordPrompt -LinkTarget myRemoteDB
RELATED LINKS
SYNOPSIS
Add an Oracle Database Link.
SYNTAX
Add-OracleDBLink [-TargetDB] <String[]> [[-DBUser] <String>] [-PasswordPrompt] [-SchemaName] <String> [-LinkName]
<String> [-LinkUser] <String> [-LinkPasswordPrompt] [-LinkTarget] <String> [[-Parallelism] <Int32>]
[<CommonParameters>]
DESCRIPTION
This function adds an Oracle Database Link.
PARAMETERS
-TargetDB <String[]>
Target Database
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-DBUser <String>
Username if required
Required? false
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-PasswordPrompt [<SwitchParameter>]
Flag to ask for a password
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-SchemaName <String>
Schema Name
Required? true
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LinkName <String>
DB Link Name
Required? true
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LinkUser <String>
DB Link Username
Required? true
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-LinkPasswordPrompt [<SwitchParameter>]
DB Link Password Promt flag
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-LinkTarget <String>
DB Link Host (Target database)
Required? true
Position? 6
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Parallelism <Int32>
Parallelism Degree
Required? false
Position? 7
Default value 1
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
-------------------------- EXAMPLE 1 --------------------------
PS C:\\>Add-OracleDBLink -TargetDB myorcl -SchemaName myuser -LinkName myDBLink -LinkUser myRemoteUser
-LinkPasswordPrompt -LinkTarget myRemoteDB
RELATED LINKS