I installed oracle 10.2.0.1 and upgraded it to 10.20.4 on windows XP,but when l log into the dbconsole, the console shows that the instance has been up since l installed 10.2.0.1, although l stopped it and did the upgrade t 10.2.04. Select * from v$version and select * from v$instance confirm am...
We are contempleting moving our current Bussines Objects software to a new and upgraded server, has amybody done this or know to do this? and how did it go?
I have just downloaded oracle 9.2.0.1 and now i want apply the 9.2.0.8 patch. I went on metalink and pulled down the following patchs. Which one of them do i use,some are bigger than others? Thanks-
Results for Platform : Microsoft Windows XP
Tip Consider Saving the search to make it easy...
That makes sense. I just wanted the two tables(employees,countries), the other three do not exist is Jesselyn's schema. What do i need to do prevent the error messages if i already know that i wont need the other three tables thus won't need to enable any constraints?
I executed the statement below to do an export and it terminated without errors.
exp username/password tables=(employees,countries) file=c:\export\home\okmaps1\expdat.dmp log=c:\export\home\okmaps1\imp.log
Then i tried to import these two tables into another schema.
using the following command...
you are right i have a hosed database. Good thing it was only a test db. I took this file offline back in july and tried to drop it. But i forgot to manually remove it instead i moved it to another folder.When i was doing a user managed recovery i restored it with the rest of the files. I've...
I was testing a recovering scenario, i took a hot backup of my database. Went back in and dropped a table. Then tried to do an incomplete recovery. Apparently i started the recovery with one of the datafile offline. I brought it back online. And since then i get this error when i try do a...
Thank mufasaa for making that clear. I question was in regards to "all of the objects (e.g., tables, indexes, et cetera) owned by all of the Oracle user/schemas (e.g., "SYS", "SYSTEM", "DBSNMP", "OUTLN", "<your login>", "<my login>", et cetera) that make up a single Oracle installation." Looking...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.