113 reputation
15
bio website stackoverflow.com
location Florida
age 41
visits member for 2 years, 8 months
seen Jun 3 at 5:09

Its not a big deal.


Sep
23
awarded  Notable Question
Feb
14
awarded  Popular Question
May
20
comment oracle 10g xe to 11g xe upgrade
Thank you. Worked with the original/classical import/export (imp/exp). Did a exp for the schema from the 10g XE. And was able to import the dump file using imp to 11g XE. With a procedure was able to compare the no. of objects both the DBs and no. of rows in the tables and no. of rows returned by the views. While doing the imp to 11g XE there were compilation warnings. But using developer did a recompile of entire schema and the procedures got compiled without issues.
May
20
accepted oracle 10g xe to 11g xe upgrade
May
18
comment oracle 10g xe to 11g xe upgrade
Do you think i will have to drop the tables after importing. That could sometime cause issues with existing procedures or could run triggers? or to the views used
May
18
comment oracle 10g xe to 11g xe upgrade
There are 2-3 tables with over 2 million rows. Will try but that will mean importing triggers, views, procedures also the custom way. since they will compile while importing?
May
18
comment oracle 10g xe to 11g xe upgrade
@miracle173 ran it with the system account and also with the schema user account. but with both says the db exceeds max limit of 4GB
May
18
comment oracle 10g xe to 11g xe upgrade
@szilard yes the entire schema. Its for moving the db to a 11g XE.
May
18
comment oracle 10g xe to 11g xe upgrade
i tried to take a backup using sql developer. But sql developer by default shows views also in its data export section. Is it necessary to take data backup of views? As far as i know views don't store data physically at all.
May
18
asked oracle 10g xe to 11g xe upgrade
May
17
awarded  Supporter
Jan
30
awarded  Scholar
Jan
30
awarded  Student
Jan
30
awarded  Autobiographer
Feb
4
asked query plan caching (sql server)