Instant Oracle Database and PowerShell How-to - Instant Oracle Database and PowerShell How-to - page 55

3. See what properties are on the connection object, as shown in the

following screenshot:

4. Create the connection object:

$conn = New-Object Oracle.Management.Omo.Connection `
-property @{UserID="HR"; Password = "pass"; TnsAlias =
"LOCALDEV"}

5. Inspect methods on the connection object:

6. Open the connection and initialize it to prepare for digging deeper:

$conn.Open(); $conn.Initialize()

7. Get a collection of table objects and list table names:

PS > $tables = $conn.GetTables($false, $true)
PS > $tables | sort {$_.Name} | foreach {$_.Name}
COUNTRIES
DEPARTMENTS
EMPLOYEES
JOB_HISTORY
JOBS
LOCATIONS
REGIONS