| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 37.1 | Owner? | HERON::ROWLANDS | Rob Rowlands @vbo 828 5480 | Wed Apr 09 1997 15:12 | 12 |
| Evelyne,
Probably it's the table owner name.
In the source anayzer, it promts you for the username/password combination, but
also for the table ownership. This depends upon the creator of the tables, and
whether they can be seen through the username/password combination.
Try 'select tablename, owner from dba_tables' in oracle to find out the owner.
(could have the field & tablenames wrong there... but it's something to that
effect).
Rob
|
| 37.2 | Ownership is OK | NEWVAX::EBARON | Evelyn Baron | Wed Apr 09 1997 17:25 | 13 |
| Rob,
I verified the ownership of the tables and it is the one I expected
(DOE_ADMIN). I created the tables using the Warehouse Designer in the
PowerMart designer, using the same connection that I am trying to use
with the Source Analyzer.
I have also created the tutorial tables in the SQL/Server database and
tried to perform the Source Analyzer and I get the same error.
Any other ideas?
Evelyn
|
| 37.3 | Is this what you did? | HERON::ROWLANDS | Rob Rowlands @vbo 828 5480 | Thu Apr 10 1997 11:47 | 13 |
| Let's see,
You manager to create tables using the Warehouse designer:
- create table & fields
- fields;
- generate SQL
- Execute SQL (were there any errors?))
and you still can't see these tables through the source analyser,
with the same connection information as you supplied with the
Warehouse Designer 'Execute SQL' ...?
(Note, you wouldn't normally want to source-analyse warehouse-designer tables,
but it's a good way of testing general connectivity issues)
|
| 37.4 | I'm using Informatical supplied scripts | NEWVAX::EBARON | Evelyn Baron | Thu Apr 10 1997 17:24 | 15 |
| The tutorial comes with scripts to create and populate tables in a
database. If you have a copy of the installation guide, the tutorial
installation is described on page 17. Running the tutorial is described
in Appendix A of the Designer's Guide. The scripts provided create the
source database. The Warehouse designer option to Execute SQL for
Warehouse Table Creation is used to create and populate the source
database.
It is puzzling that the same connection is used to create the source
database cannot read the database. Do we have an Informatica technical
contact here in the US that I can call?
Thanks for the help,
Evelyn
|
| 37.5 | | FLEXEM::HAGGERTY | Kevin, NSIS, Stow MA USA | Fri Apr 11 1997 16:05 | 2 |
| Ediz has been helpful in the past. [email protected]
|
| 37.6 | more info needed | HERON::ROWLANDS | Rob Rowlands @vbo 828 5480 | Wed Apr 16 1997 16:03 | 12 |
| Evelyn,
Could you tell me:
1) under which username/password you created the tables;
2) what you see the ownership as in the database?
There isn't any magic anywhere, it really must be a question of
username/ownership. I just went through the exercise with a German colleague
who was seeing a similar problem, and he fixed the issue by creating the tables
under a username other than SYS / SYSTEM.
I've just been through the Oracle 7.3.2 workgroup installation, and can try to
reproduce what you did...
|