Connecting Spotlight on Oracle to dB - does it create a tablespace/datafile?

About a month ago, I connected Spotlight on Oracle to a dB to monitor some activity=2E Long story short, it somehow created a new tablespace and datafile (TS/DF) called SPOTLIGHT=2Edbf=2E This is normally not a problem, but I did not realize this would be a problem for a standby database that is in managed recovery mode for this dB=2E=2E=2E(I know how to fix that, so that is not my question)=2E

My question is - what part of connecting Spotlight on Oracle to the dB would create the TS/DF? Was this something I told Spotlight to do during initial account setup? Is it the part where you configure a new user for spotlight - I know you select the tablespace to put the tables in when doing so, but I do not remember how this SPOTLIGHT tablespace got in there to be selected=2E

I connected Spotlight on Oracle to another database, trying to replicate the TS/DF creation and it didn't do anything - so I am wondering where this TS/DF came from=2E=2E=2E? Any ideas?

If the connection/setup process doesn't ever do this, then I have to assume I created it manually in anticipation of connecting Spotlight to it=2E=2E=2Eoh well=2E

Popular White Paper On This Topic

Hi,
This is part of your Initial Account setup..Is it the part where you
configure a new user for spotlight. At the Initial Setup It will
execute .sql against some .dbf files at that time your table space and
all the tables are created..
Ram

what is interesting though...I connect spotlight to another database, do the initial setup and do not see any TS/DF added. Perhaps the one time I "added" the new user a certain way, but I cannot figure out how it would do this. It lets you select the TS you want, so if it doesn't exist, it will not be in the list. How did it get there?