OriginalDBMS
Showstheoriginaldataasitappearedwhenextractedfromthedatabase.Iftheoriginaldataistoolong
anddoesnotfitintothelistbox,atruncatedrepresentationwillbeshowninstead.Itsfullvaluecanbe
displayedintheOriginalfield.
CurrentMapInfoProfessional
ShowsthedataasitappearsintheMapInfoProfessionallinkedtableyouaretryingtosave.TheMapInfo
ProfessionalfieldwillbeblankiftherecordhasbeendeletedfromtheMapInfoProfessionaldatabase.
IfthedatafromtheMapInfoProfessionallinkedtableistoolonganddoesnotfitintothelistbox,a
truncatedrepresentationwillbeshowninstead.ItsfullvaluecanbedisplayedintheMapInfoProfessional
field.
CurrentDBMS
Showsdataasitappearsintheremotedatabaseatthetimeoftheupdate.(Thisdatamighthavebeen
changedbyanotherusersinceitwasdownloadedintoanMapInfoProfessionallinkedtable.)TheCurrent
fieldwillbeblankiftherecordhasbeendeletedontheremotedatabase,afterbeingdownloadedinto
anMapInfoProfessionallinkedtable.Ifthecurrentdatafromtheremotedatabaseistoolonganddoes
notfitintothelistbox,atruncatedrepresentationwillbeshowninstead.Itsfullvaluecanbedisplayed
intheCurrentfield.
CurrentMapInfoProfessional
SelectthischeckboxtoupdatetheremotedatabasewiththevaluefromtheMapInfoProfessionallinked
table.
IfthecurrentrecordonthedatabaseortheMapInfoProfessionalrecordwasdeleted,thenthischeck
boxisnotavailable.Instead,youmustusetheMapInfoProfessionalorCurrentbutton.
CurrentDBMS
Selecttoretainthecurrentvalueontheremotedatabase.Ifthecurrentrecordonthedatabaseorthe
MapInfoProfessionalrecordwasdeleted,thenthischeckboxisnotavailable.Instead,youmustuse
theMapInfoProfessionalorCurrentbutton.
MapInfobutton
ThisbuttonselectsalltheMapInfoProfessionalvalues.Iftherecordyouaretryingtoresolvewasdeleted
fromtheMapInfoProfessionaldatabase,selectingtheMapInfobuttonwilldeletetherecordfromthe
remotedatabase.Iftherecordyouaretryingtoresolvewasdeletedfromtheremotedatabase,selecting
theMapInfobuttonwillinsertthenewrecordintotheremotedatabase.
Currentbutton
ThisbuttonselectsallthecurrentDBMSvalues.Iftherecordyouaretryingtoresolvewasdeletedfrom
theMapInfoProfessionaldatabase,selectingtheCurrentbuttonwillignorethedeletionandretainthe
currentrecordintheremotedatabase.Iftherecordyouaretryingtoresolvewasdeletedfromtheremote
database,selectingtheMapInfobuttonwillinsertthenewrecordintotheremotedatabase.
Column
Showsthefullnameofthecolumnhighlightedinthelistbox.
OriginalDBMS
Showsthefullvalueoftheoriginaldatahighlightedinthelistbox.
CurrentMapInfo
ShowsthefullvalueoftheMapInfoProfessionaldatahighlightedinthelistbox.
CurrentDBMS
Showsthefullvalueofthecurrentremotedatabasedatahighlightedinthelistbox.
StopCommit
191
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
Remove text from pdf online - delete, remove text from PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Allow C# developers to use mature APIs to delete and remove text content from PDF document
how to delete text in pdf converter; how to copy text out of a pdf
Remove text from pdf online - VB.NET PDF delete text library: delete, remove text from PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
VB.NET Programming Guide to Delete Text from PDF File
how to delete text from pdf document; pdf text watermark remover
TheStopCommitbuttonterminatestheentireupdate.Aseconddialogboxconfirmsthatthisiswhat
youreallywant.
Automatic
TheAutomaticbuttoncausestheinteractiveconflictresolutiontoend.Adialogboxdisplaystoallow
youtoselecttheautomaticconflict-resolutionmodesyouwanttousefortheremainderofthisupdate.
Youcanselectonetwoautomaticmodesfromthedialogbox.YoucanacceptMapInfoProfessional
values,orthevaluescurrentlyresidingontheremotedatabase.
DisconnectingfromaRemoteDatabase
Disconnectingfromaremotedatabaseserverisasimpleoperation.
Todisconnectfromaremotedatabaseserver:
1. FromtheDBMSToolbar,dooneofthefollowing:
• ClicktheDisconnectDBMS
tool.
• OntheFilemenu,clickCloseDBMSConnection.
2. IntheCloseDBMSConnectiondialogbox,theConnectionlistdisplaysalltheopenconnections.
Selecttheconnection(s)youwanttocloseandclickOK.
Theselectedconnection(s)close.
Youcannotdisconnectifyouhavealivetableopenusingtheconnectionyouaretryingtoclose.
Note:
WorkingwithStylesinDBMSTables
Atablemayuseonestyleforallobjectswithinatable,orcontaindifferentstylesforeachrow,called
perrowstyles(perrowstyleisoptional).Therearetworequirementsforsettingupperrowstyles:
• ArowmustexistintheDBMStable
• Youmustsetupamapcatalogentrytoactivatetherowstyle.
UsingPerRowStylesforDBMSTableLayers
PerRowStylesallowstheuseofdifferentobjectstylesonaremotedatabase.Youcanmodifythestyles
ofindividualobjectsorgroupsofobjectsandsavethemtoaDBMStable.TousePerRowStyles,the
DBMStablemustbesetupcorrectly,andyourMapInfo_MapCatalogmusthavetheappropriatestructure:
• TheMapInfo_MapCatalogmustcontaincolumnsthatsupporttheuseofstyles.Theyare:
RENDITIONTYPE,RENDITIONCOLUMN,andRENDITIONTABLE.
• Themaptableitselfmusthaveacharactercolumnwideenoughtostorethecompletestylestring.
Stylestringsvaryinwidth.Werecommendaminimumof50charactersbeprovided.Ifyouplanto
usecustomsymbols,whichusemuchlongerstrings,allow200characters.
• TheentryforthetableintheMapInfo_MapCatalogmustbesetcorrectly.Thismeansthatthe
RENDITIONTYPEis1,andtheRENDITIONCOLUMNcontainsthenameofthecolumnthatwillcontain
thestylestring.ThisentryissetbyEasyLoaderiftheMapInfo_MapCatalogcontainsthenewcolumns,
oritmaybesetusingtheMakeTableMappablefunction.
ChangingtheSymbolStyleinaMappableDBMSTable
TheChangeDBMSTableSymbolmenuoptionallowsyoutochangethesymbolattributesforthepoint
objectsinamappableDBMStable.
1. OntheTablemenu,pointtoMaintenanceandclickChangeDBMSTableSymbol.Or,selectthe
ChangeSymboltool.
2. IntheSelectDBMSTabledialogbox,selectatable.OnlymappableDBMStablesdisplay.
MapInfoProfessional12.5
192
OpeningaDBMSTableinMapInfoProfessional
C# PDF remove image library: remove, delete images from PDF in C#.
Delete Text from PDF. Text: Replace Text in PDF. Image: Insert Image to PDF. Image: Remove Image from PDF Page. Image: Copy, Paste, Cut
how to delete text in a pdf file; pdf editor delete text
VB.NET PDF remove image library: remove, delete images from PDF in
Remove PDF image in preview without adobe PDF reader PDF SDK library download and online VB.NET Except PDF text processing function, RasterEdge XDoc.PDF for
how to delete text from pdf reader; remove text from pdf online
3. IntheChangeTableObjectStyledialogbox,specifynewstyleattributesfortheobjectsinthe
selectedtable.
4. Refreshthelinkedtableforthestylechangetotakeeffect.
Working with Remote Tables from Specific
Databases
Youcanspecifywhethertoloadandworkonanentiretableoronlyspecificcolumnsorrowsfroma
table.
WorkingwithSQLServerTables
ConvertingUnsupportedGeometriesinSQLServerandSQLServerSpatialWare
SometimeswhenyouarecreatingaMapinMapInfoProfessionalandyouarestoringtheresultsinSQL
Serveryoucreatemapswhichusegeometriesthatarenotsupported:
• SQLServerSpatialdoesnotsupportarcs,andlinesthatdonothavedistinctpoints.
• SQLServerSpatialWaredoesnotsupportarcs,ellipses,androundedrectangles.
IfyouhavecreatedamapyoudonotwanttolosebutcannotsavetotheDBMSofyourchoice
duetounsupportedgeometries,thenusetheSaveAsmenuoptionandsavethemapwithout
theunsupportedgeometries.
Note:
IfyoutrytosaveamapwithunsupportedspatialgeometrytypesinSQLServerSpatialorSQLServer
SpatialWare,thesearetheresults:
• SpatialGeometryTypeswithAllUnsupportedObjects:Ifyouhavecreatedamapthatmight
containalloftheunsupportedobjectsandyouaretryingtosavetoSQLServerSpatialorSQLServer
SpatialWare,thismessagedisplays:
Table has unsupported objects (rounded rectangles, ellipses or
arcs). Convert to regions and/or polylines?
ClickYestoconverttheunsupportedobjectstoregionsorpolylines;youwouldselectNotodecline
toconverttheunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtothe
SQLServerSpatialorSQLServerSpatialWaredatabase.
• SpatialGeometrytypeswithRegionObjectsOnly:Ifyouhavecreatedamapthatcontainsregion
objectsonlyandyouaretryingtosavetoSQLServerSpatialorSQLServerSpatialWare,thismessage
displays:
Table has unsupported objects (rounded rectangles or ellipses).
Convert to regions?
ClickYestoconverttheunsupportedobjectstoregions;youwouldselectNotodeclinetoconvertthe
unsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheSQLServer
SpatialorSQLServerSpatialWaredatabase.
• ForSpatialGeometrytypeswithLineObjectsOnly:Ifyouhavecreatedamapthatcontainsline
objectsonlyandyouaretryingtosavetoSQLServerSpatialorSQLServerSpatialWare,thismessage
displays:
Arc is an unsupported object. Convert to polylines?
ClickYestoconverttheunsupportedobjectstopolylines;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheSQLServer
SpatialorSQLServerSpatialWaredatabase.
193
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
Ability to remove consecutive pages from PDF file in VB Enable specified pages deleting from PDF in Visual Basic Online source codes for quick evaluation in VB
how to delete text in pdf acrobat; delete text pdf files
VB.NET PDF Password Library: add, remove, edit PDF file password
Remove password from PDF. Dim outputFilePath As String = Program.RootPath + "\\" Remove.pdf" ' Remove password in the input file and output to a new file.
delete text pdf file; how to remove highlighted text in pdf
WorkingwithSQLServerwithSpatialWareTables
SpatialWareisaPitneyBowesSoftwareInc.Corporationproductthathelpsusersstore,access,manage,
andmanipulatespatialdataasastandardpartoftheirbusinessdata.Youcanquerybothspatialand
non-spatialdatawithinasingleSQLServerqueryusingSpatialWare.AllofthestrengthsofSQLServer
asarelationaldatabaseareextendedtospatialdatausingSpatialWare.Spatialdatamayforexample
bedirectlymanagedandeditedbymanydifferentuserssimultaneously.
CannotUploadObject
IfyoueditamappableSpatialWaretableandtrytoinsertMapInfoEllipse,RoundedRectangle,orArc
objectsintoit,thefollowingmessagedisplays:
"CannotUpload.ObjectformatisnotsupportedinSpatialWare(Ellipse,RoundedRectangle,orArc)"
Thisisbecauseyouaretryingtoinsertobjectsthatarenotsupported.Tofixtheproblem,deletethese
objectsfromthetableortransformthemtopolylinesorregions.Todeterminewhichobjectshavetobe
deletedortransformed,runaqueryintheMapInfoSQLSelectdialogboxandspecify"obj"intheSelect
Columnclause.Theresultingquerywilltellyouthetypesofobjectsinthetable.Selecttheobjectsyou
wishtodeleteortransformanddisplaytheselectioninaneditablelayerinaMapwindow.Todeletethe
objects,usetheClearMapObjectsOnlyoptionintheEditmenu.Totransformtheobjects,usethe
ConverttoRegionsorConverttoPolylinesoptionintheObjectsmenu.Forbestresults,transformEllipse
andRoundedRectanglesintoregions,andtransformArcsintopolylines.
IfyoumakeaSpatialWaretablemappablewiththeObjectTypedefaultofPointandtrytoinsertaLine
orRegionobjectintoit,thesamemessage"CannotUploadObjectformatisnotsupportedinSpatialWare
(Ellipse,RoundedRectangle,orArc)"displays.Thisisbecauseyouaretryingtoinsertobjectsother
thanapoint.YouneedtomakethetablemappablewiththeObjecttypespecifiedasALL.Tofixthe
problem,deletethetablefromtheMapCatalogusingEasyLoader.Thenre-addthetabletotheMap
CatalogwithanObjecttypeofALLusingtheMakeTableMappableoption.
WorkingwithPostGISTables
SometimeswhenyouarecreatingamapinMapInfoProfessionalandyouarestoringtheresultsin
PostGISyoucreatemapswhichusegeometriesthatarenotsupported:PostGISdoesnotsupportarcs,
ellipses,rectangles,androundedrectangles.
IfyouhavecreatedamapyoudonotwanttolosebutcannotsavetotheDBMSofyourchoice
duetounsupportedgeometries,thenusetheSaveAsmenuoptionandsavethemapwithout
theunsupportedgeometries.
Note:
IfyoutrytosaveamapwithunsupportedspatialgeometrytypesinPostGIS,thesearetheresults:
• SpatialGeometryTypeswithAllUnsupportedObjects:Ifyouhavecreatedamapthatmight
containalloftheunsupportedobjectsandyouaretryingtosavetoPostGIS,thismessagedisplays:
Table has unsupported objects (rounded rectangles, ellipses or
arcs). Convert to regions and/or polylines?
ClickYestoconverttheunsupportedobjectstoregionsorpolylines;youwouldselectNotodecline
toconverttheunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtothe
PostGISdatabase.
• SpatialGeometrytypeswithRegionObjectsOnly:Ifyouhavecreatedamapthatcontainsregion
objectsonlyandyouaretryingtosavetoPostGIS,thismessagedisplays:
Table has unsupported objects (rounded rectangles or ellipses).
Convert to regions?
ClickYestoconverttheunsupportedobjectstoregions;youwouldselectNotodeclinetoconvertthe
unsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtothePostGIS
database.
MapInfoProfessional12.5
194
WorkingwithRemoteTablesfromSpecificDatabases
C# PDF Digital Signature Library: add, remove, update PDF digital
Delete Text from PDF. Text: Replace Text in PDF. Image: Insert Image to PDF. Image: Remove Image from PDF Page. Image: Copy, Paste, Cut
erase pdf text online; erase text in pdf document
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
Free online C# class source code for deleting specified PDF pages in .NET console application. Able to remove a single page from PDF document.
how to edit and delete text in pdf file; how to delete text in pdf document
• ForSpatialGeometrytypeswithLineObjectsOnly:Ifyouhavecreatedamapthatcontainsline
objectsonlyandyouaretryingtosavetoPostGIS,thismessagedisplays:
Arc is an unsupported object. Convert to polylines?
ClickYestoconverttheunsupportedobjectstopolylines;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheSQLServer
Spatialdatabase.
• ForSpatialGeometryoftypeRectangle:Ifyouhavecreatedamapthatcontainsrectangleobjects
andyouaretryingtosavetoPostGIS,thismessagedisplays:
Cannot upload Object - Rectangle object type is not supported in this
table. Operation canceled.
ClickOK.YoucannotsavethemapyouhavecreatedtothePostGISdatabase.
WorkingwithOracleSpatialTables
OracleSpatialisanimplementationofaspatialdatabasefromOracleCorporation.Youcaninstallitin
additiontotheMapInfoProfessionalODBCConnectivitycomponent.Althoughithassomesimilarities
tothepreviousOracleSDOrelationalimplementation,itissignificantlydifferent.OracleSpatialmaintains
theOracleSDOimplementationviaarelationalschema.However,MapInfoProfessionaldoesnotsupport
theOracleSDOrelationalschemaviatheOracleCallInterface(OCI).MapInfoProfessionaldoessupport
simultaneousconnectionstoOracleSpatialthroughtheOCIandtootherdatabasesthroughODBC.
SupportedObjectTypes
TheMultipointandCollectionobjecttypesaretranslatedintotheSpatialObjectsOracleMULTIPOINT
andCOLLECTION,respectively,viaOracleOCIandviceversa.However,Oracle'sCOLLECTIONobject
isbroaderinscopethanMapInfoProfessional'sCollection,whichonlyallowsoneREGION,onepolyline
andonemultipoint.Therefore,conversionfromMapInfoProfessionalobjecttoOracleobjectsandthe
conversionfromOracleobjectstoMapInfoProfessionalobjectsmaynotbeaone-to-onetranslation.
ThefollowingtableshowstherelationshipbetweenMapInfoProfessionalobjectsandOracleobjects.
MapInfoProfessionalObjects
OracleSpatialObjects
Multipoint
MULTIPOINT
Collection
COLLECTION
Multipoint
Point(cluster)
Polyline
LineString
MultipleLineString
REGION
Polygon
MultiplePolygons
ThetableindicateshowOracleSpatialobjectsaretranslatedintoMapInfoProfessionalobjects.Allpoint
elementsinanOracleCOLLECTIONwillbetranslatedintoonemultipointinaMapInfoProfessional
Collection;allOracleLineobjects(includingsingleandmultiple)willbetranslatedintooneMapInfo
Professionalpolyline;andallOraclePolygons(includingsingleandmultiple)willbetranslatedintoone
MapInfoProfessionalREGION.Therefore,whenanOracleCOLLECTIONismodifiedandthensaved
backintoOracleServerbyusingMapInfoProfessional,theoriginalstructureoftheOracleCOLLECTION
objectmaybechangedifitismorecomplicatedthantheMapInfoProfessionalCollection.
IfyouareconnectingtoanOracleSpatialdatabase,OracleSpatialisanewspatialschemanumber13.
Itprovidessupportforpoints,lines,andpolygonspatialtypes.
195
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
C# PDF Password Library: add, remove, edit PDF file password in C#
Support to add password to PDF document online or in C# String outputFilePath = Program.RootPath + "\\" Remove.pdf"; // Remove password in the input file and
delete text pdf document; how to erase text in pdf file
C# PDF bookmark Library: add, remove, update PDF bookmarks in C#.
Ability to remove and delete bookmark and outline entry.GetLocation()); Console.WriteLine("Text: " + entry.GetText NET Sample Code: Update PDF Document Outline
delete text pdf acrobat; how to delete text in pdf file online
OracleSpatialRequirements
ToconnecttoOracleSpatialwithinMapInfoProfessional,youmusthavetheOracleSpatialorOracle
9iand9irelease2,or10Gclientinstalled.SeeyourOracledocumentationfordetailedinformation.
PrimaryKeyusedforNewTableCreationorWhenSavingaRemoteCopy
AnUniquekeyensuresthatanentrydoesnotmatchanyotherentryfromadifferentrecord.Ifarecord
doesnotcontainanyvalue,noerrorisreported.APrimarykeyrequiresthateveryrecordcontainsa
uniquevalueinthatfield.BymakingthesevaluesPrimarykeys,weenforcethateveryrecordhasa
valueinthisfield.
PrimaryKeyAuto-IncrementforOracleDatabases
ThePrimaryauto-incrementfeaturemanagesthePrimarykeyvalueforyou.Whenyouaddanewrecord
toaremoteOracletable,MapInfoProfessionallocksthetable,checksforthehighestvalueofthePrimary
keyofthetable,incrementsitbyone(1),andthenputsthatvalueinthePrimarykeyfield.SQLServer
Spatialusersdonotrequirethisfeatureastheserver-sidesoftwaremanagesthePrimarykey
automatically.
UsetheAutoKeycheckboxintheOpenDBMSTableOptiondialogboxtoenablethisfeature.When
youselecttheAutoKeycheckbox,thePrimarykeyfieldisnoteditableandtheUniquekeyisautomatically
incremented.Ifyoudonotselectthischeckbox,thePrimarykeyfieldremainseditable.
Toaccessthisfeature:
1. FromtheFilemenu,clickOpenandselectanOracledatabasefromtheFilesofTypedrop-down
list.ClickOKtodisplaytheOpenDBMSTableOptionsdialogbox.
2. SelecttheAutoKeyoptiontoincrementthePrimarykeyoftheselectedtableautomaticallyforany
newrecords.
3. ClickOKtocontinue.
OracleObjectMapVerificationSupportingObject/MapValidation
TheCheckRegionsmenuoptionenablesyoutoremoveregionlinesegmentsthatintersecteachother.
Youcanalsothinkofthisasnodeswithinasinglepolygonofaregionwherethepolygonintersectsitself,
aswhenanodehasmorethan2linesegmentsemanatingfromit.
Thesecasescanbebrokendownintotwootherinstances:
• Ifapolygonhas2loopedsections,andthepathtracedbythenodesofthepolygonfollowacursive
figure8pattern,thenwecallthisaFigure8polygon.
• Ifthesame2loopedpolygoncantraceitspathasacursivecapitalletterB,thenwecallthisaBow
Tiepolygon.
WethinkofFigure8asworsethanBowTiebecausetheareaofaFigure8isalwaysincorrect,while
theareaofaBowTiecanbecorrectandaccurate.BothFigure8'sandBowTiesaredetected.
CreatingLegendsfrom/foraLiveTable
YoucanretrieveuniquestylesfromthetableusingtheCreateLegendwizard.Youcanretrievestyles
fromthemapcatalog,ifperformanceisyourprimaryconcern,butifyoupreferamorevisuallydescriptive
andappealingspatialrepresentationoftheuniquemapstylesinyourlivetable,youcancreatelegends
fromalivetableinstead.
Whenareuniquemapstylesavailableforalivetable?
Ingeneral,remotedatabaseshavenoconsistentwayofstoringstylesforgeographicdata.MapInfo
Professionalgivesyoutwodifferentwaysofassociatingstyleswithgeographicdataforremotedatabases.
Thefirstwayistospecifyacommonstyleforadatabasetableinthemapcatalog,whichisusedforall
recordsinthatdatabasetable.Thesecondwayistohaveanadditionalcolumnforthedatabasetable
thatspecifiesastyleforeachrecordinthattable.(MapInfoProfessionalusesthemapcatalogtokeep
trackofthestylecolumnforadatabasetable.)Uniquemapstylesareavailableforadatabasetable
whenithasthisdesignatedstylecolumn.
Toseethisfunctionality:
MapInfoProfessional12.5
196
WorkingwithRemoteTablesfromSpecificDatabases
1. OpenaremoteDBMSconnectionandselectalivetablefordisplay.
2. FromtheMapmenu,clickCreateLegendtodisplaytheCreateLegend-ChooseLayersdialog
box.
3. SelectalayertocreatealegendfromandclickNexttodisplaytheCreateLegend-LegendDefault
Propertiesdialogbox.
4. ClickNexttodisplaytheCreateLegend-FramePropertiesdialogbox.
5. IntheStylesfrombox,therearethreeoptions.Thefirstoption,mapcatalog,providestheexisting
supportandisstillthedefaultforlivetables.
• Selectmapcatalogtoretrievethedefaultstylesfortheselectedlegendframefromthemap
catalog.Usethisoptionwhenyouareconcernedwithperformance.Retrievingmapstylesfrom
livetablesonaremotedatabasecantakealongtime,butretrievingadefaultstylefromthemap
catalogcanbesignificantlyfaster.Rememberthatstylesinthemapcatalogmaynotbeasvisually
descriptiveastheotheroptions.Thisisthedefaultoptionforlivetables,butisdisabledforother
typesoftables.
• Selectuniquemapstylestoretrievealluniqueobjectstylesfortheliveaccesstableforavisually
appealinglegend.Forextremelylargetables,thisoptioncantakelongerthanthefirstoption.This
optionisselectedbydefaultwhenthelegendframeisnotaliveaccesstable.
• Selectuniquevaluesinacolumntoretrievethestylesassociatedwiththevaluessavedina
particularcolumninthedatabasetableforavisuallyappealinglegend.Forextremelylargetables,
thisoptioncantakelongerthanthefirstoption.
6. ClickSaveframesettingtoMetadatatopreservethechoiceyoumadeinthisdialogbox.When
youre-openthisdialogboxthesettingsfromthemetadataareusedasdefaultvaluesinsteadofthe
systemsetdefaultvalues.
7. ClickFinish.
SeeTroubleshootingDBMSTableIssuesintheHelpSystem.
MapInfoProfessionaldoesnotMaintaintheCurveTypeinOracleData
WhenreadingOracletables,MapInfoProfessionalchangesrecordscontaininggeometriesthatdonot
directlytranslatetoMapInfoProfessionalgeometrytypes.Thishappenswhenworkingwithlinesand
polygonboundariescontainingsegmentsthatarecurvetypesorcircles.MapInfoProfessionaldoesnot
supportthecurvetype,soitconvertsthesetopolylines.MapInfoProfessionalalsoconvertscirclesinto
regions.Whensavingtheserecordsbacktothedatabase,youmaylosesometopologicalinformation
asaresult.ThisissomethingtobeawareofwhensharingyourOracledatawithotherapplications,such
asAutodesk'sMap3D.
MapInfoProfessionalshowsamessagebeforesavingdatabacktotheOracledatabasewhenthatdata
containscurvedgeometries.Themessageisasfollows:
TheOracletableyouareupdatingcontainsoneormoregeometrytypesthatMapInfoProfessionaldoes
notsupport,sothegeometrytypehasbeenconvertedtoasupportedtype.Savingthesegeometries
mayintroducetopologicalerrorsintoyourdatabase.ClickYestocontinue,orNotodiscardchanges
thatweremadetounsupportedgeometries.Editstoattributedatasaveineithercase.
WhenexecutingtheMapBasicCommitstatement,thepromptdisplaysonlywhenitcontainsthe
Interactivekeyword.
Note:
ConvertingUnsupportedGeometriesinOracle
SometimeswhenyouarecreatingaMapinMapInfoProfessionalandyouarestoringtheresultsin
Oracleyoucreatemapswhichusegeometriesthatarenotsupported:Oracledoesnotsupportarcs,
ellipses,rectangles,androundedrectangles.
IfyouhavecreatedamapyoudonotwanttolosebutcannotsavetotheDBMSofyourchoice
duetounsupportedgeometries,thenusetheSaveAsmenuoptionandsavethemapwithout
theunsupportedgeometries.
Note:
OracleGeometryConversionBehavior
197
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
IfyoutrytosaveamapwithunsupportedspatialgeometrytypesinOracle,thesearetheresults:
• SpatialGeometryTypeswithAllUnsupportedObjects:Ifyouhavecreatedamapthatmight
containalloftheunsupportedobjectsandyouaretryingtosavetoOracle,thismessagedisplays:
Table has unsupported objects (rounded rectangles, rectangles,
ellipses or arcs). Convert to regions and/or polylines?
ClickYestoconverttheunsupportedobjectstoregionsorpolylines;youwouldselectNotodecline
toconverttheunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtothe
Oracledatabase.Aconfirmationmessageexplainsthattheoperationiscanceled.
• SpatialGeometrytypeswithRegionObjectsOnly:Ifyouhavecreatedamapthatcontainsregion
objectsonlyandyouaretryingtosavetoOracle,thismessagedisplays:
Table has unsupported objects (rounded rectangles, rectangles, or
ellipses). Convert to regions?
ClickYestoconverttheunsupportedobjectstoregions;youwouldselectNotodeclinetoconvertthe
unsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheOracledatabase.
• ForSpatialGeometrytypeswithLineObjectsOnly:Ifyouhavecreatedamapthatcontainsline
objectsonlyandyouaretryingtosavetoOracle,thismessagedisplays:
Arc is an unsupported object. Convert to polylines?
ClickYestoconverttheunsupportedobjectstopolylines;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheOracle
database.
OracleOperatingSystemAuthenticationandConfiguration
WhenyouchooseOSauthenticationforauser,theuseraccountismaintainedbytheOracledatabase,
butpasswordadministrationanduserauthenticationisperformedbytheOperatingSystem(OS).With
OSauthentication,yourdatabasereliesontheunderlyingoperatingsystemtorestrictaccesstodatabase
accounts.Adatabasepasswordisnotusedforthistypeoflogin.
Bydefault,Oracleallowsoperating-system-authenticatedloginsonlyoversecureconnections,which
precludesusingOracle.NETandasharedserverconfiguration.Thisdefaultrestrictionpreventsaremote
userfromimpersonatinganotheroperatingsystemuseroveranetworkconnection.
SettingREMOTE_OS_AUTHENTtoTRUEinthedatabaseinitializationparameterfileforcestheRDBMS
toaccepttheclientoperatingsystemusernamereceivedoveranon-secureconnectionanduseitfor
accountaccess.
Anychangetothisparametertakeseffectthenexttimeyoustarttheinstanceandmountthedatabase.
Generally,userauthenticationthroughthehostoperatingsystemoffersfasterandmoreconvenient
connectiontoOraclewithoutspecifyingaseparatedatabaseusernameorpassword.Also,userentries
correspondinthedatabaseandoperatingsystemaudittrails.
SettingPrefixforOSAuthenticatedUser
SettheinitializationparameterOS_AUTHENT_PREFIX,andusethisprefixintheOracledatabaseuser
names.TheOS_AUTHENT_PREFIXparameterdefinesaprefixthattheOracledatabaseaddstothe
beginningofeveryuser'soperatingsystemaccountname.Whenauserattemptstoconnect,Oracle
comparestheprefixedusernamewiththeOracleusernamesinthedatabase.
Forexample,assumethatOS_AUTHENT_PREFIXissetasfollows:
OS_AUTHENT_PREFIX=OPS$
TheinitializationparameterOS_AUTHENT_PREFIXiscase-sensitiveinsomeoperatingsystems.
RefertoyouroperatingsystemspecificOracledocumentationformoreinformationaboutthis
initializationparameter.
Note:
IfausernamedtsmithistoconnecttoanOracledatabaseinstallationandbeauthenticatedbythe
OperatingSystem,thentheOracledatabasecheckswhetheracorrespondingdatabaseuserOPS$tsmith
MapInfoProfessional12.5
198
WorkingwithRemoteTablesfromSpecificDatabases
exists.Ifso,theuserwillconnect.AllreferencestoauserauthenticatedbytheOperatingSystemmust
includetheprefix,OPS$,asseenintheexampleOPS$tsmith.
ThedefaultvalueofthisparameterisOPS$forbackwardcompatibilitywithpreviousversionsofOracle
databases.However,youmightprefertosettheprefixvaluetosomeotherstringoranullstring(an
emptysetofdoublequotes:"").Usinganullstringeliminatestheadditionofanyprefixtooperating
systemaccountnames,sothatOracleusernamesexactlymatchoperatingsystemusernames.
AfteryousetOS_AUTHENT_PREFIX,itshouldremainthesameforthelifeofadatabase.Ifyouchange
theprefix,thenanydatabaseusernamethatincludestheoldprefixcannotbeusedtoestablisha
connection,unlessyoualtertheusernametohaveitusepasswordauthentication.
CreatingaUserwhoisAuthenticatedbytheOperatingSystem
ThefollowingstatementcreatesauserwhoisidentifiedbyOracleandauthenticatedbytheoperating
systemoranetworkservice.ThisexampleassumesthatOS_AUTHENT_PREFIX = "".
CREATE USER scott IDENTIFIED EXTERNALLY;
UsingCREATEUSER<username>IDENTIFIEDEXTERNALLY,youcreatedatabaseaccountsthat
mustbeauthenticatedbytheoperatingsystemornetworkservice.Oraclewillthenrelyonthisexternal
loginauthenticationwhenitprovidesthatspecificoperatingsystemuserwithaccesstothedatabase
resourcesofaspecificuser.
SeetheOracleDatabaseAdvancedSecurityAdministrator'sGuide
(http://docs.oracle.com/cd/B19306_01/network.102/b14268/toc.htm)formoreinformationabout
externalauthentication.
199
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
Documents you may be interested
Documents you may be interested