294 IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization
Figure A-22 Database created
The simple database has been created successfully.
Create simple table using wizards
To create a table called HISTORY in our simple sample database SALES, do the
following:
1. To start the Enterprise Manager Console, click Start -> Programs -> Oracle
- OraHome92 -> Enterprise Manager Console. On the Oracle Enterprise
Manager login window choose Launch standalone and click OK.
Appendix A. Sample Oracle Enterprise Edition installation 295
Figure A-23 Running Enterprise Manager Console in standalone mode
2. On the tree view, double-click Network -> Databases ->
SALES.ITSO.RAL.IBM.COM to open the SALES database administrative
console.
Figure A-24 Opening the SALES database administrative console
3. Enter the administrator’s user name and password. Click OK.
296 IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization
Figure A-25 Enter administrators username and password
4. Expand the Schema object for database SALES. Expand the SYSTEM
schema. Right-click Tables and select Create Using Wizard.
Figure A-26 Create table using wizard
5. Enter a name for the new table to be created, for example, HISTORY. Click
Next.
Appendix A. Sample Oracle Enterprise Edition installation 297
Figure A-27 Specify table name
6. Specify all the columns in the table. Click Add for each column to bring it to
the Columns defined list. When you finish, click Next.
298 IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization
Figure A-28 Add columns
7. Define primary keys by clicking in the Order column. Click Next.

Get IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.