11g xe workspace with OLEDB connection string
900859Nov 18 2011 — edited Nov 18 2011I am trying to use C# oledb to connect ORACLE 11g XE database with the connection string:
Provider=OraOLEDB.Oracle;Data Source=localhost:1521/ex;User ID=system;Password=xxxxx;
I can create connection and get all table metadata (> 100 tables) list including system table information which I am not interested in. Actually I log into http://localhost:8080/apex/f?p=4500:3002:2546245833875081::NO:::, the system asks me to enter info for Workspace, Username and password, after I log in, I only see 1 table there, which is correct, I only created 1 table there a few days ago.
So my question is how to specify workspace inside connection string to narrow down the table list?
Edited by: 897856 on Nov 18, 2011 9:57 AM
Edited by: 897856 on Nov 18, 2011 9:57 AM