All Questions
Tagged with oracle10g oracle-11g
10
questions
8
votes
4
answers
140k
views
How to restore/import an Oracle database from dmp file?
I've recently received the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now I need to restore the original database.
Can anyone give me a step by step procedure ...
2
votes
2
answers
348
views
Oracle (xe) 10 vs 11 . Have I lost the SQL tuning pages ? Am I going out of my mind?
Ok .. so perhaps the title needs calming down a bit.
Basically I am after the XE 11g equivalent of the pages that you can see here, in which you can then navigate to stuff like "top 50 queries" and "...
1
vote
10
answers
5k
views
What is the best OS platform for Oracle 10g? [closed]
I want to know the best choices for OS to run Oracle 11g on my sand box.
Also, I would like to know good combination for Dev environments in 50-100 user environments.
Any other information about ...
1
vote
4
answers
10k
views
Running Oracle 10g and 11g side-by-side
I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a ...
1
vote
2
answers
189
views
How to connect an Oracle server between two countries and maintain high speeds for read & write
Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, ...
1
vote
1
answer
548
views
Oracle Internet Directory implementation questions?
I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the TNSNAMES....
1
vote
0
answers
774
views
migrate 10g xe to 11g xe
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 ...
0
votes
2
answers
10k
views
Oracle 11g: Why doesn't "grant create session" allow user to log in?
I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there ...
0
votes
1
answer
503
views
Where to create directory for importing over network link?
While using data pump import over network link in Oracle:
impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT
directory=TEST_DIR remap_schema=SCOTT:TEST
Where are we creating ...
0
votes
1
answer
111
views
DataSet.Fill slower after upgrading to oracle 11g
We have migrated from an oracle 10g to an oracle 11g Database.
The instance of Database 11g is totally new an installed on a VirtualMachine in a different HW. The new DB is on Windows Server 2013 ...