Viewing 15 posts - 1,171 through 1,185 (of 3,061 total)
Jo Pattyn (2/17/2011)
Apparently changed with oracle 10ghttp://decipherinfosys.wordpress.com/2007/04/28/writing-data-to-a-text-file-from-oracle/
This is one of those interesting scenarios where both of us are right.
I was right when I said "Oracle external tables are read-only -...
February 18, 2011 at 4:06 pm
Jeff Kring (2/18/2011)
February 18, 2011 at 3:27 pm
sqlchanakya (2/17/2011)
I was just trying to convey like whats the significance of unique key while creating indexes...
mmhhh... to enforce uniqueness perhaps? 😀
February 17, 2011 at 10:18 am
Jo Pattyn (2/15/2011)
...or try to write to "external tables"
Oracle "external tables" are read-only - no DML activity is allowed.
February 17, 2011 at 10:14 am
sqlgreg (2/17/2011)
Thanks, guys. Jo, I ended up using the spool option to spool the results of a query with a custom delimiter (pipe) into a text file.
Out of curiosity... what...
February 17, 2011 at 10:12 am
sqlgreg (2/11/2011)
That certainly explains it 😀
February 13, 2011 at 4:31 pm
miriyalasrihari (2/8/2011)
WHAT ARE THE MINIMUM SYSTEM REQUIREMENTS TO BUILD A DATA WAREHOUSE...................WITH MICROSOFT OS
Volume?
Concurrency?
Volatility?
Daily ETL or near-real-time?
Size of user community?
February 10, 2011 at 8:43 am
Sideout1972 (2/9/2011)
ssills (2/9/2011)
February 10, 2011 at 8:36 am
Did you commit?
Post definition of the table,
Post session showing update statement.
February 9, 2011 at 1:46 pm
Sideout1972 (2/9/2011)
PaulB-TheOneAndOnly (2/9/2011)
1.b - How about having two FactPolicyTransaction columns named AgentPolicy and AgentTransaction.
I assume FactPolicyTransaction table will be sliced...
February 9, 2011 at 1:32 pm
Sideout1972 (2/9/2011)
February 9, 2011 at 12:54 pm
Check for scheduled jobs - this may be some sort of a monitoring tool.
February 9, 2011 at 11:12 am
najibphl (2/8/2011)
i need to make a description of all the steps that must...
February 8, 2011 at 8:05 am
winston Smith (2/8/2011)
Most systems will have a downtime,...
February 8, 2011 at 7:58 am
srilu_bannu (2/8/2011)
We have a job that is being run for the past 4 years and it never failed due to this reason.The job fetches the data from OLEDB Linked...
February 8, 2011 at 7:34 am
Viewing 15 posts - 1,171 through 1,185 (of 3,061 total)