FmPro
Migrator Features and Benefits
FmPro
Migrator Demo Available for download...
Bookmark
This Page
-- Script: contact_management_create_table1.sql
-- Features: This sql script creates the Oracle
-- user, tablespace and table for the
-- FileMaker data.
--
-- Notes: The DBA should update the start
-- and increment values of the sequence
-- before running this script.
--
-- The DBA should change the VARCHAR2(4000)
-- column sizes to appropriate values to
-- permit indexing of the columns. Oracle
-- permits indexes of up to 768 total column
-- sizes unless the Oracle Text
-- (formerly Context) feature is being used.
--
-- CLOB/BLOB datatype columns may be stored
-- within locally managed tablespaces
-- with Oracle 9.2.0. Otherwise, a dictionary
-- managed tablespace should be used.
--
-- This file only needs run if
-- the existing user, table and tablespaces
-- do not already exist in the destination
-- database.
--
-- Usage: sqlplus /nolog @contact_management_create_table1.sql
--
-- Used By: run manually by Oracle DBA on the database server
-- Copyright 2003 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 2-27-2003 dsimpson Initial Release
--
-- This output file was created by FmPro Migrator version 1.23 on Thu
Apr 3 12:21:05 2003. By .com Solutions Inc. www.dotcomsolutionsinc.net
--
connect / as sysdba
CREATE TABLESPACE "USERS" LOGGING DATAFILE '/u01/prod1/users01.dbf'
SIZE 10M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE 51200K EXTENT MANAGEMENT
LOCAL AUTOALLOCATE;
connect / as sysdba
CREATE TABLESPACE "INDX" LOGGING DATAFILE '/u01/prod1/indx01.dbf'
SIZE 10M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE 51200K EXTENT MANAGEMENT
LOCAL AUTOALLOCATE;
connect / as sysdba
-- create database account
CREATE USER user1 IDENTIFIED BY "user1pwd"
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT CONNECT TO user1 WITH ADMIN OPTION;
GRANT RESOURCE TO user1 WITH ADMIN OPTION;
connect user1/user1pwd
-- create Oracle table to match structure of FileMaker file
CREATE TABLE user1.contact_management
(
last_name VARCHAR2(4000) NULL,
first_name VARCHAR2(4000) NULL,
company VARCHAR2(4000) NULL,
title VARCHAR2(4000) NULL,
street_1 VARCHAR2(4000) NULL,
city_1 VARCHAR2(4000) NULL,
state_province_1 VARCHAR2(4000) NULL,
postal_code_1 VARCHAR2(4000) NULL,
notes VARCHAR2(4000) NULL,
phone_1 VARCHAR2(4000) NULL,
date_created DATE NULL,
date_modified DATE NULL,
identification_number VARCHAR2(4000) NULL,
image_data BLOB default EMPTY_BLOB() NULL,
template_information_global VARCHAR2(4000) NULL,
created_by VARCHAR2(4000) NULL,
last_layout NUMBER NULL,
email VARCHAR2(4000) NULL,
phone_2 VARCHAR2(4000) NULL,
current_date DATE NULL,
similar_by VARCHAR2(4000) NULL,
similars_key VARCHAR2(4000) NULL,
similars_multikey VARCHAR2(4000) NULL,
similars_count NUMBER NULL,
similars_tab_label VARCHAR2(4000) NULL,
similar_name_key VARCHAR2(4000) NULL,
similar_company_key VARCHAR2(4000) NULL,
street_2 VARCHAR2(4000) NULL,
city_2 VARCHAR2(4000) NULL,
state_province_2 VARCHAR2(4000) NULL,
postal_code_2 VARCHAR2(4000) NULL,
address_type_1 VARCHAR2(4000) NULL,
address_type_2 VARCHAR2(4000) NULL,
scratch VARCHAR2(4000) NULL,
thumbnail BLOB default EMPTY_BLOB() NULL,
contact_id NUMBER NULL,
most_recent_form_layout NUMBER NULL,
letter_body_text VARCHAR2(4000) NULL,
email_address_with_name VARCHAR2(4000) NULL,
thumbnail_display BLOB default EMPTY_BLOB() NULL
)
TABLESPACE users
LOGGING
STORAGE (BUFFER_POOL DEFAULT)
NOPARALLEL
NOCACHE;
COMMENT ON TABLE user1.contact_management IS
'Table created by FmPro Migrator containing data from FileMaker Pro';
quit
