No question at this time
DBA Top 10
1 A. Kavsek 10600
2 M. Cadot 8900
3 B. Vroman 5600
4 P. Wisse 4800
5 J. PĂ©ran 2000
6 . Lauri 1000
7 D. Johnson 300
8 J. Van Der Steen 200
8 G. Muijrers 200
8 R. Chandran 200
8 G. Am77 200
8 B. Bartben 200
8 N. Abdul Rahman 200
8 J. Akhtar 200
8 F. Dumaguin 200
8 R. Rakotozafy 200
8 D. Ramakrishna 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48497
Total active users1452
Act. users last 24h7
Act. users last hour0
Registered user hits last week218
Registered user hits last month669
Go up

disable advance compression and partitions
Next thread: PSU for databases
Prev thread: auto upgrade from 11.2.0.4 to 18.3.0.0

Message Score Author Date
Hi Guys I have a data warehouse database that w...... Tso P Feb 04, 2020, 07:49
4 steps: 1/ import with sqlfile option 2/ modi...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Michel Cadot Feb 04, 2020, 09:15
Thanks Michel ... Tso P Feb 04, 2020, 09:46
Hello Tso, and I assume that one of the reasons...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Bruno Vroman Feb 04, 2020, 10:34

Follow up by mail Click here


Subject: disable advance compression and partitions
Author: Tso P, South Africa
Date: Feb 04, 2020, 07:49, 63 days ago
Os info: solaris 11
Oracle info: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
Message: Hi Guys

I have a data warehouse database that we refresh weekly using the data pump.

Now, the tables that we copy from the transactional database are created with advanced compression and partitions.

On the data warehouse database, we don't want to have the advanced compression and the partitions.

For partitions, I will try PARTITION_OPTIONS=merge so that we don't have partitions.

How can I import these tables without advanced compression?

Thanks in advance.

Please help !!!



Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: disable advance compression and partitions
Author: Michel Cadot, France
Date: Feb 04, 2020, 09:15, 63 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message:
4 steps:
1/ import with sqlfile option
2/ modify the generated file to remove the partitioning and compression clauses
3/ execute the modified file
4/ import with data_only option

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: disable advance compression and partitions
Author: Tso P, South Africa
Date: Feb 04, 2020, 09:46, 63 days ago
Message: Thanks Michel

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: disable advance compression and partitions
Author: Bruno Vroman, Belgium
Date: Feb 04, 2020, 10:34, 63 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello Tso,

and I assume that one of the reasons is the license cost... But once the option has been used, the license is due, even if you stop using the feature.
The usage is written in the database; you can see it in DBA_FEATURE_USAGE_STATISTICS, or you can have a look at the MOS document 1317265.1 Database Options/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c

So what can be done: export the data, destroy the database, create a brand new database, import the data (making sure that you will not use the features, see Michel's answer)

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here