Database DataWarehousing (MOSC)

MOSC Banner

Difference Between General Purpose and Data Warehouse

edited Jan 27, 2020 1:14PM in Database DataWarehousing (MOSC) 9 commentsAnswered
Dear Sir/Madam,
  In creating database using DBCA there are choices such as Data Warehouse and General Purpose and Transaction Processing. We are creating a report server which includes transactional data and table whose size is almost 80gb, since we do not purge inventory items. May I know what's the difference between the  General Purpose and Data Warehouse,. How about the performance? or are there any special set up when using data warehouse? It will be my first time using data warehouse if it suites to y requirements.

Regards,
Dexter

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center