Data Migration Support

Invisible Columns in Oracle 12c

By | Oracle Tips, Technology Tips & Tricks
Invisible column is a new feature in Oracle 12c.  Invisible columns provide a convenient way to change a table’s structure without having to edit the existing applications using that table.   Invisible columns can be created at the time of table creation using CREATE TABLE command                                 SQL> create table inviscol_test                                 2  (compno number,                                 3  compname varchar(20),                                 4  compcode varchar(10) invisible);                                 Table created.   existing visible columns can be modified to invisible using ALTER TABLE command                                 SQL> alter table inviscol_test modify (compname invisible);                                 Table altered.   How does it work?   The insert statement where we don’t specify the column names will fail.                                 SQL> insert into inviscol_test values (101,'ABCD','A101');                                 insert into inviscol_test values (101,'ABCD','A101')                                 *                                 ERROR at line 1:                                 ORA-00913: too many values                                 Explicit column names should be included in the insert statement.                                 SQL>  insert into inviscol_test(compno, compname, compcode) values                                 (101,'ABCD','A101');                                 1 row created.   If invisible columns are not listed in the insert statement they are set to NULL                                 SQL>  insert into inviscol_test values (201);                                 (more…)
Oracle

Oracle 12c New Feature – Multiple Indexes On The Same Column Or Set of Columns

By | Oracle Tips, Technology Tips & Tricks | No Comments
Starting with Oracle 12c, multiple indexes on same column or same set of columns can be created, as long as only one index is visible, and the indexes are physically different. It is not possible to create two bitmap indexes on the same column or set of columns. Example: Create a table ind_test1 SQL> create table ind_test1(id number, dept  varchar(20), start_dt date); Table created. Insert rows SQL>  insert into ind_test1 values(111, 'TEST', to_date('01/01/2000','mm/dd/yyyy')); 1 row created. SQL>  insert into ind_test1 values(222, 'DEVL',  to_date('10/25/2011','mm/dd/yyyy')); 1 row created. SQL>  insert into ind_test1 values(333, 'TEST',to_date('05/22/1999','mm/dd/yyyy')); 1 row created. Select * from ind_test1 table SQL> select * from ind_test1; ID DEPT                 START_DT ---------- -------------------- --------- 111 TEST                 01-JAN-00 222 DEVL                 25-OCT-11 333 TEST                 22-MAY-99     Create the first index on start_dt column. By default, Oracle creates B-tree index. SQL>  create index idx1_ind_test1 on ind_test1(start_dt); Index created.   Now, create a second invisible index on the same column SQL> create index idx2_ind_test1 on ind_test1(start_dt) invisible; create index idx2_ind_test1 on ind_test1(start_dt) invisible * ERROR at line 1: ORA-01408: such column list already indexed   Index failed because these 2 are the same type of indexes. You can create a bitmap index on the same column. SQL>  (more…)

Dobler Consulting Recognized by Inc5000 as Top IT Services Company in Tampa Bay

By | Company News, General Announcements, What's New | No Comments
For the first time in its company history, Dobler Consulting was featured in the prestigious Inc5000 listing. The class of 2017 named 79 companies from the Tampa Bay area among the nation’s fastest growing companies. To join the ranks of Tampa Bay’s fastest growing companies on the national stage is a great honor. We know how hard it is to achieve growth and success on an accelerated path. Congratulations to our fellow neighbors and Inc5000 honorees from the Tampa Bay. The Tampa Bay Times published a prominent article and quoted; “Among the 11 IT services firms ranked here, Tampa’s 55 employee Dobler Consulting Services landed at the highest spot at No. 1002 on the Inc.5000 with a growth rate of 432 percent. Peter Dobler founded the business in 2008.” We’ve been working hard to build an organization modeled on providing critical services to companies around the globe who are in need of database management, design, support and migration. As part of our accelerated growth and dedication to supporting any database platform, we added Microsoft Gold Partner (Data) and an Oracle Gold Partner to our list of achievements. Being featured on the Inc5000 list is not just a huge honor, but (more…)
sybase recovery services

In-Memory Databases vs Intel NVMe NUMA

By | Blog, Database Technology Trends, SAP HANA, Sybase | No Comments
For the past few years, the hot topic for database vendors was the in-memory database. The general belief was and maybe still is, that server memory is getting cheaper and density will continuously improve. For the most part, this has been the case, maybe not as extreme as predicted. However, the data storage needs for databases increased at a much faster pace during the same time, which created another problem. Going beyond 1TB of memory in a single server will quickly become very expensive. A 1TB database used to be called very large. This attribute is now applied to the 5-10 TB databases servers. In-memory databases are needed where read and write performance are equally important. Traditional databases improve read performance by caching data in memory, but there is no way to improve write performance. To be ACID (Atomic, Consistent, Isolated and Durable) compliant, data must be written to persistent storage. An in-memory database achieves this by writing every transaction in parallel to a high-performance storage. In many cases this is a flash drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory (RAM) to be ACID compliant. There are many (more…)
Oracle Gold Partner

Dobler Consulting Becomes Oracle PartnerNetwork Gold Level Partner

By | Press Releases | No Comments
July 17, 2017 – Dobler Consulting Services LLC, a database services and solution company, today announced that it has achieved Gold Partner status in Oracle PartnerNetwork (OPN). By attaining Gold Level membership, Oracle has recognized Dobler Consulting for its commitment to establish Oracle related knowledge in delivering professional services to its Oracle clients and for uniquely addressing the challenges of joint customers migrating into the Oracle Cloud.   “Thanks to our recent growth, we’ve been able to diversify our services while still maintaining the highest levels of expertise,” said Peter Dobler, CEO and Founder of Dobler Consulting, LLC. “As an Oracle Gold Partner, we have created a new department which is dedicated to Oracle service delivery, focusing on cloud deployment.”   With its Gold status, Dobler Consulting receives the benefit of being able to start developing specializations that will allow them to grow their business, increase their expertise, reach higher levels of customer retention, and create differentiation in the marketplace. Gold members also become eligible to resell all Oracle Technology products and can apply to resell Oracle Applications and Industry Solutions. In addition, they receive access to Oracle account representatives and My Oracle Support updates for all products, discounts on (more…)
SQL Server

Planning And Executing A Successful SQL Server Database Migration

By | White Papers | No Comments

By Carlos Colon / DBA Manager at Dobler Consulting

Migrating an existing database to SQL Server can be a taunting task. No matter if your current database is Oracle, Sybase, DB2 or MySQL, the core of the migration tasks are almost always identical. A SQL Server database migration project can be broken down into 6 steps.

1. Analysis
2. Planning
3. Build
4. Migrate, Test, Fix, Repeat
5. Deployment
6. Support

This presentation will walk you through these steps and in addition will also cover these topics:

– Typical SQL Server Migration Plan
– Key Deliverables
– Database Migration Steps
– Brief Overview of SQL Server Migration Assistant Tool (SSMA)
– Common Problems in Database Migrations

Download the Guide For FREE!!

Read More

Oracle Showcase

By |
X
Overview > Category Category > Product

Categories

No Results

 

 

Products

No Results

 

 

Resources

No Results

Integrated Cloud Applications & Platform Services
{{zval(RES.RDisplayName)}} {{zval(RES.RDisplayName)}}
 
{{zval(RES.RDisplayName)}}
{{zval(RES.RDisplayName)}}

 

 
     

 

 

{{zval(CAT2.DisplayName)}}  
 
{{zval(CAT2.DisplayName)}}  
 

 

 

Additional Resources

{{zval(RES.RDisplayName)}} {{zval(RES.RDisplayName)}}
 
{{zval(RES.RDisplayName)}}
{{zval(RES.RDisplayName)}}

 

 
     

 

 

 

{{zval(PRO.DisplayName)}}

Let us help you get started

Contact us today
Dobler ConsultingDobler Consulting Services LLC is a member of the Oracle PartnerNetwork.
X

Contact Us For More Information

Contact Us

Thank You

A representative will be contacting you shortly.
X

 

Please fill out the form below to get access to  

DOWNLOAD

 

Click the link below to download  

DOWNLOAD

        Share this:TweetShare on TumblrWhatsAppEmailLike this:Like Loading... (more…)

Protecting Your Database from Ransomware like WannaCry

By | Blog | No Comments
You may have heard about the recent WannaCry cyberattack that infected hundreds of thousands of computers worldwide. The ransomware holds a computer hostage until the user pays some amount of money (ransom) to the hacker or until a patch is made and installed. Why did it spread so quickly and how can you prepare for the next one, especially if you are a DBA? It’s not a matter of if, it’s a matter of when. Why were the attacks so effective? When this particular ransomware emerged on May 12th 2017, it had used an exploit on Windows systems that had been addressed by a critical patch two months earlier in March 2017. So, if end users kept up to date with receiving the latest critical security patches as they became available, they would have avoided being infected. Unfortunately, many businesses were not adequately prepared for an attack like this because maintain updates and they did not have the right security processes in place. It’s critical that companies are proactive in the measures they take to mitigate the risks involved with today’s cyber threats or they will become vulnerable. Lack of preparedness is one of the biggest factors why this cyber (more…)

Dobler Consulting is Pleased to Announce the Formation of Its Board of Advisors

By | Press Releases | No Comments

Tampa, FL (PRWEB) April 11, 2017

Dobler Consulting, LLC. (doblerconsulting.com) is pleased to announce the formation of its Board of Advisors.

Founded in 2008, Dobler Consulting empowers businesses to get the most from their databases with expertise in SAP, Sybase, Microsoft and Oracle.

Read More

SQL Server MySQL Sybase SAP SharePoint MongoDB Oracle Cassandra

Remote Database Support

By | Blog, Oracle, Preserved Content Pages, SAP HANA, SAP Sybase, SQL Server, Sybase | No Comments
Get Around the Clock Database Support at an Affordable Price. Traditional remote database support services offer services based on your install base, if you need it or not. We offer a new approach of database managed services that goes beyond the databases and covers the entire user experience of any application. Remote DBA Support Plans and Pricing   We Support These Systems SAP Sybase ASE 16 SAP Sybase IQ SAP Sybase Replication Server SAP Sybase PowerDesigner SAP Sybase PowerBuilder SQL Anywhere SAP HANA SAP BusinessObjects Microsoft SQL Server 2016 Microsoft SharePoint Oracle Database 12c Golden Gate Oracle RAC Oracle Enterprise Manager MySQL Times Ten In-Memory Database Discover the Difference Managed Oracle Database Services Can Have on Your Business The basic concept of a remote database support is to lower the cost of database administration. Traditionally, remote database support was offered to large enterprise corporations with entire teams of databases. The goal was to do the same at a lower cost. This is just another form of outsourcing.   The Right Remote Database Support Service Model For You Our remote database support approach is one of the most flexible in the business. It is geared towards small and medium businesses that have a one or more applications (more…)
%d bloggers like this: