TOM Repository Setup, Oracle script

[Charlie]

Hello,

I'm looking at the Oracle script (tm_ora10.sql, provided with TD5.2-SP3) to setup the TOM repository.

It seems odd to me that every reference to a table is qualified with the "TMADM" schema name, yet there is no statement to create that schema.

I'm also not quite sure I understand why the default script has the user TMADM setup with a default tablespace "USERS". Wouldn't it make sense for the default tablespace to be "TMADM"???

Have I missed something in the documentation? Where does it specify the step of creating the TMADM schema?

Much appreciated.

[Jeff Luther]

Well, I'm not familiar with that script, and from your msg. I can't tell if this is an 'info only' issue or there's a problem lurking underneath that you didn't mention explicitly.

I just looked at the script file and after that long remark (maybe you didn't see that the top section is a remark) below the '/' a couple lines is:
#Section TMADM

CREATE USER TMADM
IDENTIFIED BY TMADM
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

every reference to a table is qualified with the "TMADM" schema name

TMADM looks to the be the owner name -- or is this what you mean by 'schema' ?

Last, did you run the script? If not, I'd suggest that. And if so and you found a problem, what is it?

[Charlie]

Hello Jeff,

Thanks! Our DBA made a few small mistakes in modifying that script, and I had confused "schema" with "tablespace" completely as I was trying to figure out the mistake.

Taking a step back to look at this again later.

[Jeff Luther]

modifying that script
What?!? (Just kidding...) I shutter every time someone mods. SQL.INI, a script or other 'canned' item that's shipped with TD. 'Cause guess what, something can break.

[Charlie]

I know, I know. But it seems to be the only way to get things working. Besides, your own documentation mentions that as an option ... although I couldn't find instructions on doing that.)

Just a note with what comes with TD5.2: although you have Oracle 7 and Oracle 10 scripts (tm_ora7.sql and tm_ora10.sql), the Repository Setup Wizard does not ask which script we want to use ... it knows about and expects just the tm_ora7.sql one.

This trial and error process to get Team Object Manager working pretty well forced me into ignoring the wizard and working directly with the scripts.

The documentation for setting up TOM is not really useful. To properly setup the repository in Oracle, a complete "how to" might be worthwhile, with a script in the right order, or a series of scripts to be executed in a specified order. Some little hints and tips along the way might not be a bad thing (like a reminder on how to log in as SYS in SQLTalk ... I had forgotten about how to do that.)

As is, I'd recommend not using the repository setup wizard unless the repository is going on SQLBase. (I'd change my mind if there was a good case study of a successful setup on Oracle.)

I've got everything working, I think. Although a pain, it was very much worth it. I like Team Object Manager / Team Windows. It "just fits" with everything.

Cheers!