Skip Headers
Oracle® SQL Developer Supplementary Information for Microsoft Access Migrations
Release 3.0

Part Number E18459-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  H  I  J  L  M  N  O  P  Q  R  S  T  U  V 

A

advanced server features, 2.2
application startup performance, 5.3

B

building a mapping query, B.2

C

CASCADE UPDATE referential integrity constraints, B.5
CASCADE UPDATE trigger code, B.5
change default data types, 3.3
client/server, 2.2
column validation, B.4
Config, 5.2

D

Data Access Objects, 2.1
database users in the Oracle Model, 2.2.5
declarative default values, B.3
declarative referential integrity, 2.1.3
default data type mappings, 3.3
drivers
ODBC, 5.1
drop-down lists, 5.5.3
dynaset, 2.1.1
dynasets and primary keys, 2.3

E

emulation of COUNTER data type, B.1
errors
modifying Microsoft Access database, 4.6
explicit transaction model, 2.1.5
extending, application, 2.6

F

field names
length considerations, 2.4.1
spaces replaced by underscores, 2.4.1
FORCE option
used to create views, 3.5

H

hard lock, 2.1.2

I

implicit transaction model, 2.2.4

J

Jet, 2.1
Jet data types, 3.2
Jet error message classes, A.1
Jet error messages, A.2
Jet multi-user updates, 2.1.2
Jet recordsets, 2.1.1
Jet transactions, 2.1.5

L

large-scale application, 5.1

M

Microsoft Access data types, 3.2
migration process, 2
modify Microsoft Access database
errors, 4.6
MSysConf table, 5.2
multi-user Microsoft Access application, 2.1

N

nValue, 5.2

O

ODBC, 2.2.4
ODBC drivers, 5.1
OMWB_EMULATION user, 2.2.5
one-to-many cardinality, 2.1.3, B.5
one-to-one cardinality, 2.1.3, B.5
optimistic locking, 2.1.2
Oracle architecture, 2.2
Oracle data types, 3.1
Oracle reserved words, 3.4

P

parameter table, 5.2
performance of ODBC drivers, 5.1
performance of snapshots and dynasets, 5.5.2
pessimistic locking, 2.1.2
pivot tables
migration of TRANSFORM statements, 3.6
PL/SQL, 2.2.2
preparing for migration, 2.4
primary keys and dynasets, 2.3

Q

qualified queries, 5.5.1
queries
conversion to Oracle views, 3.5

R

reduce network traffic, 5.5.1
referential integrity, 2.1.3
relations with queries, 4.2
removing Microsoft Access security, 4.1
reserved word conflicts, 3.4
restricted queries, 5.5.1
result sets, large, 5.5.2
result sets, small, 5.5.2

S

security, removing Microsoft Access, 4.1
sequence, 2.2.3
sequence, definition, B.1
single-user Microsoft Access application, 2.1
snapshot, 2.1.1
stored procedures, 2.2.1
supported Oracle data types, 3.1

T

table names
length considerations, 2.4.1
spaces replaced by underscores, 2.4.1
table validation, B.4
transactions, 2.1.5
TRANSFORM statements for pivot tables
migrating, 3.6
triggers, 2.2.1
tuning, 5

U

users
in the Oracle Model, 2.2.5

V

views
migration of Microsoft Access queries, 3.5
need to recompile or rebuild without FORCE option, 3.5