Hi all

I'm having problems with a remote connection by sftp. I'm using public key to connect avoiding the passwd request. The correct key is added to the authorized_keys file.

The problem is...

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!!

Two possible ways:
- Make more users (one for each windows user).
- Make the resource public (with public = Yes or guest ok = Yes) in /etc/samba/smb.conf

There's no sense in putting only a user...

Try install an ODBC driver for Linux
http://www.easysoft.com/developer/interfaces/odbc/linux.html

Then you can install an access connector and make a connection directly to the .mdb file through...

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...

in gnome is possible typing man:command in the url bar.

in KDE I think Konqueror can do it through KIO slave, but I don't know. With a script or something may be possible:

For the videos, maybe the problem is shockwave plugin. There is no plugin for linux.
An open alternative: http://www.gnu.org/software/gnash/
but don't work in some cases.

About the wine problem...

To create a new user you need to use useradd (see the help file to do it properly).
To create a folder use mkdir with root and use chown to change the propietary user of the folder.
Use chmod 666...