Tagged Questions
0
votes
0answers
49 views
How to clone a database from one environment to a database on another environment?
OS: RHEL
DB: Oracle 11g version 11.1.0.7.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
4
votes
1answer
148 views
Is there a way to export an Oracle database to a CREATE DATABASE command?
I have an existing Oracle 11 instance, I want to export the database (which was created via DBCA) to an equivalent "CREATE DATABASE" command, handling the character set, etc. I'd also like to get a ...
4
votes
1answer
208 views
Comments in EXPDB parameter file
Is there a way to put comments in a data pump export parameter file?
0
votes
2answers
1k views
oracle 10g xe to 11g xe upgrade
The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
2
votes
1answer
556 views
Oracle imp crashes without error
I have Oracle 10g XE database locally. I export schema with something like
exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp
Exp is 10.2.0.1.0 version - so is the DB.
Than I take ...
5
votes
3answers
639 views
How can a datapump export have its resource usage limited on windows?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
8
votes
1answer
280 views
How can a datapump export have its resource usage limited on linux?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
