| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2010-08-16 : 14:26:25
|
....Donkey Droppings...quote:
The compile script is built on any invalid objects (tiggers/constraints/stored functions/procedures/packagtes). There are certain objects which might have dependencies on others. So the first compile script will validate most of the objects, and the second script will catch all those which have not been validated the first (due to dependencies). This is standard Oracle practice.
So there is only 1 level of dependencies?So you don't actually know what's in the database?ScrubBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-16 : 14:29:48
|
| Where is that quoted from? |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-08-16 : 16:14:00
|
| Standard practice? Glad it's not my shop!!!Terry-- -- Everyone is entitled to be stupid, but some abuse the privilege. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2010-08-17 : 11:18:34
|
quote:
Originally posted by X002548So there is only 1 level of dependencies?
Maybe its your standard "Kimball Star Schema".________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-17 : 13:06:20
|
quote:
Originally posted by X002548
quote:
Originally posted by robvolk
Where is that quoted from?
In an Email to your's trulyBrett
I checked all my emails and didn't get anything from you or SQLTeam. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-17 : 13:21:27
|
| Ahhh, the light bulb is now on. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-17 : 13:31:24
|
Here..run this...@echo offsqlplus -s %1/%2@%3 < %5\alt01.mdu > %Temp%\dbi1.logsqlplus -s %1/%2@%3 < %5\trunc.mdu >> %Temp%\dbi1.logsqlplus -s %1/%2@%3 @%5\RLS.mdu %1 > %Temp%\dbi1rls.logsqlplus -s %1/%2@%3 < %5\createJavaTab.mdu >> %Temp%\dbi1.logimp %1/%2@%3 FILE=%4 BUFFER=30720 SHOW=NO IGNORE=YES GRANTS=NO INDEXES=YES ROWS=YES FULL=YES LOG=%Temp%\DBI2.LOGsqlplus -s %1/%2@%3 @%5\Schema_statgen.mdu %1 > %Temp%\dbschema_gen.logecho ***** Compiling DB Objects ***** > %TEMP%\dbi3.logecho Script I >> %TEMP%\dbi3.logecho -------- >> %TEMP%\dbi3.logsqlplus -s %1/%2@%3 < %5\CompileAllObjects.mdu > %Temp%\Cobj.mduecho EXIT; >> %Temp%\Cobj.mdutype %Temp%\Cobj.mdu >> %TEMP%\dbi3.logsqlplus -s %1/%2@%3 @%Temp%\Cobj.mdu >> %TEMP%\dbi3.logecho Script II >> %TEMP%\dbi3.logecho --------- >> %TEMP%\dbi3.logsqlplus -s %1/%2@%3 < %5\CompileAllObjects.mdu > %Temp%\Cobj.mduecho EXIT; >> %Temp%\Cobj.mdutype %Temp%\Cobj.mdu >> %TEMP%\dbi3.logsqlplus -s %1/%2@%3 @%Temp%\Cobj.mdu >> %TEMP%\dbi3.log@echo onecho offcls Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-17 : 13:36:39
|
| Does that require me to install Oracle? Cause that ain't happening any time soon. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-17 : 14:14:57
|
| It's really just overcomplicated bat files, were they got very clever...Only problem is, you don't see the calling program and it's parameters...I changed that all, so the parameters are set in the driver...There is NO WAY...that this being reused by multiple processes...so the concept of reusability doesn't exist...Just a way to obsfucate realityI think that's the first class in Oracle 101Titled: "There is no way anyone can tell what you are doing, so you'll be safe when you funk up"Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-18 : 05:16:38
|
"Does that require me to install Oracle?"I was trying to think of a smart answer, and there it was ... right in front of me  "I think that's the first class in Oracle 101"Looks more like Job Protection to me ... although if they teach that in Oracle 101 maybe I took the wrong Fork. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-18 : 10:43:57
|
| I don't think installing Oracle is a 100-level course. More like post-grad or even post-doc. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-18 : 11:25:43
|
Fun to give the New Hire on Day One though ...  |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-08-23 : 08:39:42
|
| I was off of work the day our new Oracle DBA started (I am the SQL DBA). I was told after four hours, he looked out the window (12th floor), left and never came back. My guess: After seeing the environment, found the simplest escape route and took it. Never even met the guy - maybe a good thing!Terry-- -- Everyone is entitled to be stupid, but some abuse the privilege. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-08-23 : 09:56:58
|
quote:
Originally posted by tosscrosby
I was off of work the day our new Oracle DBA started (I am the SQL DBA). I was told after four hours, he looked out the window (12th floor), left and never came back. My guess: After seeing the environment, found the simplest escape route and took it. Never even met the guy - maybe a good thing!Terry-- -- Everyone is entitled to be stupid, but some abuse the privilege.
If you know you're going to hate working someplace, it's best to leave quickly.I have had several jobs that I quit in less than 4 hours. I won't go into details, but I never regretted those decisions. CODO ERGO SUM |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-08-23 : 19:07:01
|
Might be time to update the resume....seem like there a change in the wind....Anyone got a winning resume format?quote:
00:51:35 I feel a change in the wind, says I. 00:51:38 I'll find us a crew. There's bound to be some sailors on this rock crazy as you. 00:51:42 One can only hope.
...oye...quoting Disney fluff...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2010-08-25 : 14:22:02
|
quote:
Originally posted by tosscrosby
I was off of work the day our new Oracle DBA started (I am the SQL DBA). I was told after four hours, he looked out the window (12th floor), left and never came back. My guess: After seeing the environment, found the simplest escape route and took it. Never even met the guy - maybe a good thing!Terry
Am I the only one who read this statement the first time though as "He jumped out of the 12th floor window"?Tim S. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-25 : 17:04:54
|
quote:
Originally posted by X002548Anyone got a winning resume format?
This guy:http://twitter.com/mvelicfound this:http://twitpic.com/2hqwxwBut I don't know what site it's from.If you've got a Mac with iWork there are a number of nice resume templates in the Pages app. I got my current job using one of them. Don't have anything handy to show but if you really want one email me. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-26 : 05:13:06
|
quote:
Originally posted by TimS
Am I the only one who read this statement the first time though as "He jumped out of the 12th floor window"?Tim S.
No |
|
|
|
Next Page
|
What a Load of....