Viewing 15 posts - 481 through 495 (of 3,060 total)
I agree with Johan - what calls my attention is not that second statement fails (which is expected) but that third statement shouldn't work and apparently it does work.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 19, 2012 at 8:53 am
Rowles (2/18/2012)
What percentage of SSIS packages that are used are for data warehousing?Are SSIS packages used frequently with third party applications?
1- It all depends, if a given organization has no...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 18, 2012 at 4:53 pm
ColdCoffee (2/17/2012)
PaulB-TheOneAndOnly (2/17/2012)
What tool would you use to screw togheter two pieces of wood? a hammer or a screwdriver?
Both the tools bond 2 pieces of wood.
I would ask...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 4:08 pm
Loundy (2/17/2012)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 2:48 pm
GSquared (2/17/2012)
PaulB-TheOneAndOnly (2/17/2012)
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading it...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 2:01 pm
If you want to get rid of the data use truncate.
If you want to get rid of the object use drop.
What tool would you use to screw togheter two...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 1:56 pm
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading it into a...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 11:10 am
sqlvogel (2/16/2012)
we use "star (schema) design", which is a synomym for "dimensional design" for Kimballistic Data Warehouse databases and we use "relational design" for OLTP databases.
That's seriously inaccurate. The star...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 10:51 am
...as an alternative:
SELECT OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DECODE(NULLABLE, 'Y', 'NULL', 'NOT NULL')
FROM dba_tab_columns
WHERE OWNER = '???' --<< Plug Schema Name Here
ORDER BY OWNER, TABLE_NAME, COLUMN_ID
;
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 17, 2012 at 10:40 am
sqlvogel (2/14/2012)
PaulB-TheOneAndOnly (2/14/2012)
star schemas are not relational, they are dimensional.
Maybe you don't really mean that Paul? Star schema is a design pattern quite commonly seen in relational database design. "Dimensional"...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 16, 2012 at 10:40 am
nick.mcdermaid (1/23/2012)
... relational star schema
star schemas are not relational, they are dimensional.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 14, 2012 at 9:33 am
Jo Pattyn (2/13/2012)
Somewhere on this forum there is a link to various Oracle-forums
You can try http://www.dbasupport.com/forums/forumdisplay.php?f=20
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 13, 2012 at 11:20 am
rocky_498 (2/12/2012)
I am very new in Oracle. I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?
Either...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 12, 2012 at 1:06 pm
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.
Gosh... it's a whole lot more than that....
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 12, 2012 at 11:20 am
Rowles (2/10/2012)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 11, 2012 at 2:54 pm
Viewing 15 posts - 481 through 495 (of 3,060 total)