Skip to Main Content
Forums

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Astrology Java Program- a tough question

843789Feb 26 2010 — edited Feb 26 2010
I need someone to help me in my project...here is the question:

Write an astrology program. The user types in his or her birthday(month,day,year),
and the program responds with the user's zodiac sign, the traits associated with each sign
the user's age(in years,months,day), the animal sign for the year(e.g., Year of the Pig,
Year of the Tiger), the traits associated with each animal sign, and if the year is a leap
year or not. The dates covered for each sign can be searched through the horoscope section
of a newspaper or through the internet. Then enhance your program so that if the user is one
or two days away from the adjacent sign, the program outputs the nearest adjacent sign as well
as the traits associated with the nearest sign. The month may be entered as a number from 1 to 12
or in words, i.e.,January to December. Limit the year of the birthday from 1900 to 2010 only.
The program should allow the user to repeat the entire process as often as desired.
You can use this imports:

import java.text.DateFormat;
import java.util.Date;
import java.util.Calendar;

thanks for your reply! I am hoping for your kind consideration!

Comments

ORASCN

Hi MK,

Before starting the Extract process, you should add minimal supplemental logging in both database level and goldengate level.

Database - ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;


GoldenGate - ADD TRANDATA SCHEMA.*;


or for the particular name you should mention it as


ADD TRANDATA SCHEMA.TABLE_NAME;


Regards,

Veera

1 person found this helpful
unknown-2698904

Thanks a lot Veera my friend,

Should I perform the above command at the source database only or both source and target?

How do I know which table was not added?

Actually I did run the following:

GG> add extract zextr, tranlog, begin 2014-12-02 11:00:00

GG> add exttrail /home/oratest/gg/dirdat/cx, extract zextr, megabytes 5

GG>  add trandata AP.AP_ACCOUNTING_EVENTS_ALL

GG>  add trandata AP.AP_AE_HEADERS_ALL

GG>  add trandata AP.AP_AE_LINES_ALL

GG>  add trandata AP.AP_AWT_GROUP_TAXES_ALL

GG>  add trandata AP.AP_AWT_TAX_RATES_ALL

GG>  add trandata AP.AP_BANK_ACCOUNTS_ALL

GG>  add trandata AP.AP_BANK_BRANCHES

GG>  add trandata AP.AP_CHECKS_ALL

GG>  add trandata AP.AP_INVOICE_DISTRIBUTIONS_ALL

GG>  add trandata AP.AP_INVOICE_PAYMENTS_ALL

GG>  add trandata AP.AP_INVOICES_ALL

GG>  add trandata AP.AP_PAYMENT_SCHEDULES_ALL

GG>  add trandata AP.AP_TAX_CODES_ALL

GG>  add trandata APPLSYS.FND_USER

GG>  add trandata APPS.XX_DISCRETE_JOB_INTERFACE

GG>  add trandata APPS.XX_PO_RECEIPT_INTERFACE

GG>  add trandata APPS.XX_SUBINVTR_INTERFACE_IN

GG>  add trandata AR.AR_CASH_RECEIPT_HISTORY_ALL

GG>  add trandata AR.AR_CASH_RECEIPTS_ALL

GG>  add trandata AR.AR_PAYMENT_SCHEDULES_ALL

GG>  add trandata AR.AR_RECEIVABLE_APPLICATIONS_ALL

GG>  add trandata WIP.WIP_DISCRETE_JOBS

GG>  add trandata WIP.WIP_ENTITIES

GG>  add trandata WSH.WSH_DELIVERY_ASSIGNMENTS

GG>  add trandata WSH.WSH_DELIVERY_DETAILS

ORASCN

Hi MK,

You should execute the commands in source database and source GoldenGate.

Regards,

Veera

Sent from Samsung Mobile

1 person found this helpful
unknown-2698904

Hi my friend Veera,

Yes I saw in the docs provided by the previous dba who configured it that she had run those commands you mentioned as follows:

  1. 3.1  Switch the database to archivelog mode & enable logging:

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

SQL> alter database add supplemental log data;

SQL> alter system set recyclebin=off scope=both; ( not for 9i )



How do I know if  those commands you mentioned was not being run?


Anyways I rerun it again as follows:


        SQL>  alter database add supplemental log data;

        Database altered.



But still the status is abended



Please help....

Thanks


unknown-2698904

Hi dear friend Veera,

When I run again the command > alter database add supplemental log data;

The next morning I check the status and the extract is now good and running

Do I need to rerun this command on regular basis, like if we bounce the database?

Thanks a lot.

ORASCN

Hi Maria,

Cool Not required.

Regards,

Veera

1 person found this helpful
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 26 2010
Added on Feb 26 2010
3 comments
493 views