Skip Headers

Oracle Migration Workbench Frequently Asked Questions (FAQ)
Release 9.2.0 for Microsoft Windows 98/2000 and Microsoft Windows NT

Part Number A97247-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

A  B  C  D  E  G  I  J  L  M  O  P  R  S  T  U 


A

accessing
client applications, 1-12

B

BCP
generating
SQL*Loader scripts, 4-7
bitwise operations, 4-18

C

calling
cross-database procedures, 4-18
case-sensitivity
schema objects, 1-13
cast operations
support for, 4-9
character strings
implicit date conversion, 1-13
client applications
accessing, 1-12
comparing
Oracle Transparent Gateway, 1-4
complex case statements, 4-20
configuration, 1-5
configuration file, 1-6
creating
repository, 1-6
cross-database procedure calls, 4-18
customizing
storage options, 1-14
cyclic procedures
avoiding, 4-11

D

data loading
constraints, 1-7
controlling files, 1-10
data types
mapping, 1-8
modifying, 1-7
modifying DATATIME, 4-8
modifying TIMESTAMP, 4-8
data types, modifying VARCHAR, 4-8
databases
Microsoft SQL Server, 4-4
date conversion
for character strings, 1-13
DDL commands, 4-18
DLL statements
stored procedures, 4-18
double brackets
using, 4-9
downloading, 1-3
dynasets, 4-14

E

editing
schema objects, 4-9
table defaults, 1-14
error messages, 1-11, 3-10
creating Oracle Model, 1-9
foreign keys, 1-12
hostdef, 1-12
loading source database, 1-9
logging, 1-16
Microsoft Access ODBC driver, 3-4
more information, 1-4
Sybase ODBC translator, 4-4
exporter
for Microsoft Access, 3-2

G

global variables, 4-21
@@SERVERNAME, 4-23
@@SPID, 4-23
@@TRANSTATE, 4-24

I

IDENTITY columns, 4-22
incomplete
source database, 1-10
incomplete repository, 1-9
installation, 1-5
installing
Migration Workbench, 1-6

J

Java Runtime Environment
default location, 1-7

L

logging
error messages, 1-16

M

memo columns
tables, 3-12
Microsoft Access 2000
migrating, 3-2
Microsoft SQL Server 6.0
support for, 4-2
migrating
multiple databases, 1-14
modifying
Microsoft Access, 3-11
multi-character field delimiters, 1-14
multiple databases, 1-14

O

object names, 1-5
duplicates, 1-8
ODBC
comparing to outer joints, 4-20
offline data loading, 4-5
SQL*Loader, 3-11
operations
bitwise, 4-18
Oracle Transparent Gateway
comparing, 1-4
Oracle7 databases, 4-2
Oracle8
support, 1-2
ordering, 1-3
outer joints
comparing, 4-20
converting, 4-19
migrating, 4-19

P

parsing
DUMP commands, 4-10
EXEC statements, 4-9
expression handling, 4-10
LOAD commands, 4-10
stored procedures, 4-18
SYSOBJECTS, 4-9
performance tests, 4-7
platforms, 1-2
privileges, 4-3
pseudo columns, 4-24
purchasing, 1-3

R

re-creating
repository, 1-6
REF CURSOR
weak, 1-5
relations
within Microsoft Access 95, 3-8
renaming
schema objects, 1-13
replica databases, 3-9
repository
creating, 1-6
incomplete, 1-9
re-creating, 1-6
reserved words, 1-8
result sets, 4-14
roles, 4-3
rules
getDate functions, 4-25
handling, 4-25

S

schema objects
case sensitivity, 1-13
editing, 4-9
migrating, 1-13
renaming, 1-13
scripts
Microsoft Access, 3-11
SQL*Loader, 4-5, 4-7
source database
incomplete, 1-10
SQL statements
LIKE clause, 4-10
SQL*Loader
loading data, 1-10, 1-11
SQL*Loader scripts, 4-5
BCP, 4-7
stored procedures
DLL statements, 4-18
migrating, 4-17
multiple result sets, 4-12
parsing, 4-18
support, 1-15
for Oracle8, 1-2
for Unix, 1-2
help, 1-15

T

table defaults
editing, 1-14
tables
customizing options, 1-14
memo columns in Microsoft Access, 3-12
Microsoft SQL Server, 4-4
testing
performance, 4-7
tnsnames.ora file, 1-6
Oracle home instances, 1-7

U

Unix
support, 1-2
user-defined types
handling, 4-4
using
LIKE clause, 4-10

Go to previous page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback