Viewing 15 posts - 2,341 through 2,355 (of 3,061 total)
You can always try Oracle Migration Workbench but the naked truth is most of the time you would have to rewrite the procedure from scratch. Read the SQL Server version,...
September 9, 2009 at 11:06 am
pandeharsh (7/24/2009)
I am newbie in oracle.Should we use cursor in oracle store procedure either in select statement or insert statement.
A cursor would always be populated by a select statement no...
September 9, 2009 at 11:02 am
jimk (9/9/2009)
what's the best way to handle the situation where you want a column to be nullable, but when there is data you want it to be unique?
Something is wrong...
September 9, 2009 at 10:56 am
Wayne (9/9/2009)I need to create a huge table (more than 500 million rows and 50 columns) in SQL Server. One of my coworkers told me that I should split this...
September 9, 2009 at 8:51 am
The key is to keep core structure in 3NF and be prepared to allow some degree of de-normalization in reporting delivery tables.
September 9, 2009 at 8:41 am
question is... have you migrated databases to another place or are you guys shuting down the operation?
September 9, 2009 at 8:08 am
tgarland (9/9/2009)
September 9, 2009 at 8:05 am
Paul White (9/9/2009)
No, no - crontab = awesomeness 🙂
as a friend of mine uses to say "everything that works ends up to be based on a text file" 😀
September 9, 2009 at 7:52 am
Bhuvnesh (9/9/2009)can anyone tell me why he dropped the partioned , just to regain space ?
1- One or more unwanted partitions have data = are allocating space
2- Team lead purges...
September 9, 2009 at 7:49 am
tgarland (9/9/2009)
Backup and recovery in our case is second to manageability and performance since we can easily recreate a customer's data fairly quickly.
Well... if recovery would be based in re-creating...
September 9, 2009 at 7:44 am
Paul White (9/9/2009)
Crontab. Well well well 😎
okay, okay ... you can go with dbms_scheduler system package if you want but it will take ten times longer to deploy.
September 9, 2009 at 7:29 am
tgarland (9/9/2009)
If I go with partitioning, I can separate each company on it's own filegroup
IMHO paritioning is not the right tool to solve a multi tenant environment.
Two issues with the...
September 9, 2009 at 7:24 am
Paul White (9/9/2009)
Is there a way to automate that process these days?
Oh yes, you can automate it.
1... pack provided sql code into a .sql file
2... write a shell script that...
September 9, 2009 at 7:10 am
Jeff Moden (9/8/2009)Maybe not like that, but I've used it in relation to derived tables
You are correct. Smart people are able to do all kinds of magic like using rownum...
September 9, 2009 at 7:05 am
Paul White (9/9/2009)Oracle provides indexes on functions directly I think...?
You are correct once again. Oracle do supports "function based indexes".
Last but not least, in the Oracle world applying a function...
September 9, 2009 at 7:00 am
Viewing 15 posts - 2,341 through 2,355 (of 3,061 total)