This error

ERROR: ORA-12154: TNS:could not resolve service name

only appears when you don't have an instance of a database or you don't have the listener on.

Make sure you have the DB online...

Those courses provide plenty of documentation to assistands. Probably for the money you pay, you'll have a complete slide presentation (on paper, the same as the speaker is using) and some extra...

I was just reading your code and I have a question:

Are the variables names ok?
Maybe you need to name the 'ID' vars different. IDo and IDn for example.

Maybe the problem with the update is...

umm that's the solution as I explained the problem... but I explained it bad. Sorry. ;)

I've doing a periodic load of a file with about 3000 records. The problem is that the new files (each 2...

Hi

I'd like to know if is possible update a record when load a table. The update must be over a record with a primary key.

For example:

I have a record with: id|date_begin|date_end|data...

Thanks for the quick response. I'm developing a PL/SQL for doing that over a staging table.

I think is the best way to control the data loaded and del the old data.

Thanks!!

But that doesn't limit the amount of space occupied by the main table. I'd like the disk space remain limited by the number of days and avoiding reject records by not enough space error.

Thanks!!

To do 2 updates or more you only have to add your lines to the script. But be sure to make a commit at the bottom as alit2002.

You can add as many querys as you need.

If you have just inserted...

I think the best way is creating a fact table that has all the information. To relate that information all fields must be equals.

The table would be:...

Hello everybody

My problem is that I'm quite new in oracle admin/dev so I need some help pointing me how to limit the number of days of data stored in a table.
I have some datasources that come...

Is possible that the default password has been set: try sqlplus sys/CHANGE_ON _INSTALL as sysdba

Anyway you need to have the database listener ON. In Windows try to begin the service. In unix try...