Home » RDBMS Server » Backup & Recovery » import to raw device database
import to raw device database [message #74767] Mon, 14 February 2005 04:12 Go to next message
ulli
Messages: 24
Registered: September 1999
Junior Member
Hello,

IHAC who wants to import data into a raw device based database. The export was done from a filessystem database. The problem they have is, the imported data in the raw device database needs the doublesize in the tablespaces. Why?

Greetz Ulli
Re: import to raw device database [message #74768 is a reply to message #74767] Mon, 14 February 2005 05:09 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

I don't understand what you are trying to say. You can import and export to databases despite how their datafiles are managed - filesystem, RAW or ASM - it does not matter!

Best regards.

Frank
Re: import to raw device database [message #74771 is a reply to message #74767] Mon, 14 February 2005 05:20 Go to previous messageGo to next message
ulli
Messages: 24
Registered: September 1999
Junior Member
The problem is that the tablespaces in the raw-device database are 2 times greater than in the database where they are exportet from.

Ulli
Re: import to raw device database [message #74772 is a reply to message #74771] Mon, 14 February 2005 06:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there might be any reasons.
the indexes might be created in same tablespace in new database.
the tablespace storage values may be changed.
Re: import to raw device database [message #74779 is a reply to message #74772] Mon, 14 February 2005 23:17 Go to previous message
ulli
Messages: 24
Registered: September 1999
Junior Member
Hello,
there were no changes in the create scripts for the database, just the switch from filesystem to raw device. For know we have tested it twice.
1. create the database with filesystem and import, everything was as expected,
2. create database with raw devices and import, every tablespace needs double size as on filesystem.

It is Suse Linux with Oracle 9.2 .

Greetz Ulli
Previous Topic: archived log files question
Next Topic: archive log question
Goto Forum:
  


Current Time: Sun Dec 22 22:37:45 CST 2024