Hi DBA2008, I recommend you to create all the structure first, then import all the data. Pre-create tablespaces, users, and tables in the new database to improve space usage by changing storage parameters. When you pre-create tables using SQL*Plus, either run the database in the original database compatibility mode or make allowances for the specific…
Category: Questions
How to create a Temp Tablespace Group on 10g? by America OTN Forum
Tablespace Groups Oracle now has the concept of grouping multiple tablespaces together in what they call a tablespace group. This allows you to create multiple temporary tablespaces, assign these temporary tablespaces to a tablespace group, and then use the tablespace group as the default temporary tablespace for the database or user. The benefit this has…
can someone tell any difference between express edition and standard edition for oracle 10g – by seyiisq -OTN Forum
Oracle XE: Express Edition (XE) is a free, downloadable version of the Oracle database server. Oracle XE can only be used on single processor machines. It can only manage up to 4 GB of data and 1 GB of memory. ISVs can embed XE in 3rd party products and redistribute it freely. Oracle Standard Edition:…