< Back

Add-OracleDBLink

Thu Jan 16, 2020 8:27 am

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