
	Home > Ask the Oracle Database / Applications Experts > Oracle database design and architecture Questions & Answers > Separate database for each client in Oracle 10g

Ask The Oracle Expert: Questions & Answers

Separate database for each client in Oracle 10g

Brian Peasland

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

>

QUESTION POSED ON: 23 May 2007
We need to create a data warehouse in Oracle 10g. The idea is to create a separate database for each client. The source databases are Sybase databases residing on different database servers. In Sybase we have a concept of separate databases per database server. I need to adapt the same concept in Oracle 10g. Is there some way by which I can do this? The OS will be either Linux or Unix. If I create a single database with multiple tablespaces for each client, will that be efficient as far as performance, tuning and maintenance is concerned? What would you suggest? Thanks.

Digg This!

StumbleUpon Toolbar

StumbleUpon

Del.icio.us

Add to Google

RELATED CONTENT

	Oracle database design and architecture
	Can I download DBCA for Oracle Express Edition?
	How to recreate an Oracle index in a new schema with the CREATE command
	Using Oracle Universal Installer to install Oracle with Pro*C
	Defining Oracle database repository vs. information repository
	Can I create multiple schemas in Oracle for one user?
	ORA-12514 error when connecting to the Oracle database through Toad
	Solving the ORA-00904 error: invalid identifier in Oracle
	How to tune SQL UPDATE statements for an Oracle 10g upgrade
	Will queries run slower in a smaller Oracle buffer cache?
	Using a database link to connect two Oracle apps instances

Oracle database design and architecture

Can I download DBCA for Oracle Express Edition?

How to recreate an Oracle index in a new schema with the CREATE command

Using Oracle Universal Installer to install Oracle with Pro*C

Defining Oracle database repository vs. information repository

Can I create multiple schemas in Oracle for one user?

ORA-12514 error when connecting to the Oracle database through Toad

Solving the ORA-00904 error: invalid identifier in Oracle

How to tune SQL UPDATE statements for an Oracle 10g upgrade

Will queries run slower in a smaller Oracle buffer cache?

Using a database link to connect two Oracle apps instances

Oracle data warehousing

Exadata: A first look at Oracle's entry into the appliance market

Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed

Oracle's Top 8 stories of 2008

IOUG chief discusses OpenWorld, DBA pay and security

Oracle enters the appliance market with Exadata

Tip: Exposing logical attributes with virtual columns

Oracle users prepare for MDM

Data modeling tools no substitute for hard work

eHarmony spurns Microsoft, finds match with Oracle 10g

Help with data warehouse disaster recovery planning

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

E. F. Codd (SearchOracle.com)

extent (SearchOracle.com)

flexfield (SearchOracle.com)

foreign key (SearchOracle.com)

multidimensional database (SearchOracle.com)

object-oriented database management system (SearchOracle.com)

quad tree (SearchOracle.com)

relational online analytical processing (SearchOracle.com)

row (SearchOracle.com)

splay tree (SearchOracle.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

In Sybase or SQL Server, you have a concept of a "database." However, Oracle uses that term differently. Oracle's term which most correctly matches Sybase's "database" is the "schema." In Oracle, you'll create a schema by creating a user. That schema will hold all of the objects you would normally put into a Sybase database.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

Products

About Us | Contact Us | For Advertisers | For Business Partners | Site Index | RSS

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy