إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

Oracle Maps


4 رد (ردود) على هذا الموضوع

#1 qs_samer

qs_samer

    عضو

  • الأعضــاء
  • 13 مشاركة

تاريخ المشاركة 22 March 2007 - 05:34 PM

ملف مرفق  mapviewerapiamples__JSP_.pdf   554.04كيلو   304 عدد مرات التحميل Salam,

First of all thank you so much for this great effort. I'd really appreciate all of your hard work.
I have an interest to start building a map application using oracle map builder,mapviewer, and some other API funtionality.
(note i have attached some documents about mapviewer
Please if there is anybody want to share developing this kind of system, im ready
to send all of the documentation which i have ,and start working as a team to get
more experience and knowledge about this new technology.

Also, I have a question about exp/imp oracle schema,users objects
right now i have a development database running on ORACLE10g, and i want to export
the current user object and import it to and another environment running on ORACLE9i
I searched the net and I've come to the conclusion that you cant export from higher and import to lower version??!!

if anyone has information about this issues, please forward it me .

finally,sorry for posting my subject in english.
Samer
Oracle application developer
Computer Sciences Corp.
Virginia/USA



#2 sakr_orcl

sakr_orcl

    عضو نشط

  • الأعضــاء
  • 314 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 26 March 2007 - 08:33 AM

1- On Server 9i make connection to Server 10G using (net configuration assistant) and name it for example (newserv)
2- on server 9i make export(exp userid=db10/db10@newserv file=c:\expfrom10g.dmp full=y log=c:\expfrom10g.log

--db10 -- user name and password for DB 10g
3- try imp this file to ur 9i


ربنا آتـنا في الدنيا حسنة وفي الآخرة حسنة وقنا عذاب النار.
وقل ربي زدني علما.
من عمل بما علم أورثة الله علم ما لم يعلم

sakr_orcl@yahoo.com
----------------------------
خليل صقر

#3 qs_samer

qs_samer

    عضو

  • الأعضــاء
  • 13 مشاركة

تاريخ المشاركة 29 March 2007 - 08:09 PM

Thank you so much sakr_orcl
I didnt try ur solution yest, but its make sense to me

Thanks

#4 eddy

eddy

    مشترك

  • الأعضــاء
  • 133 مشاركة

تاريخ المشاركة 29 March 2007 - 11:36 PM

thanx 4 the file

Senior Developer


#5 aghazal

aghazal

    عضو

  • الأعضــاء
  • 1 مشاركة

تاريخ المشاركة 10 March 2009 - 01:41 PM

Dear Salem...
thank you for posting this important topic...
i'm really working on this issue from one year and i have a great application that is dynamically builds a map, legend, clickable layers stored in Oracle Database 11g
and i have several resources from the net.
i wish that we can share information together...
please contact me so that we can work together

and about imporint and exporting metadata objects you can do the following "and by the way it's an easy way"
1- create table xxx_styles as select * from user_sdo_styles, create table xxx_themes as select * from user_sdo_themes, create table xxx_maps as select * from user_sdo_maps, and create table xxx_cached_maps as select * from user_sdo_cached_maps.
2- export your schema by the command "EXP".
3- in the new database import your schema by the command "IMP"
4- after finishing the import run the sql plus and connect to your schema and enter the following:
inset into user_sdo_styles (select * from xxx_styles)...etc "repeat that for the other tables".
now all your metadata are loaded into the new database or schema.