meta user
network profile
| bio | website | stackoverflow.com |
|---|---|---|
| location | Florida | |
| age | 39 | |
| visits | member for | 1 year, 3 months |
| seen | Jun 29 '12 at 6:08 | |
| stats | profile views | 3 |
Its not a big deal.
|
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) |
