08-12-2013
Quote:
Originally Posted by
rbatte1
Ask your DBA what account the databasde runs as. If you are the DBA, ask the OS SysAdmin. If you are both, then ........
Robin
Probably database runs as
oracle user and i use it as
usr_1 user.
I am not the admin nor DBA
10 More Discussions You Might Find Interesting
1. Solaris
I am using oracle 9i with sun solaris 8 on Sun E 250 server.earlier we are taking backup of oracle archive files on /orabackup directory.in which archive file are stored with ...arc.Z extension. now we have changed the archive backup directory.now when we are trying to delete earlier directory... (3 Replies)
Discussion started by: mahanalok
3 Replies
2. Shell Programming and Scripting
Hi,
I have a file abcd.txt which has contents in the form of full path file names i.e.
$home> vi abcd.txt
/a/b/c/r1.txt
/q/w/e/r2.txt
/z/x/c/r3.txt
Now I want to retrieve only the directory path name for each row
i.e
/a/b/c/
/q/w/e/
How to get the same through shell script?... (7 Replies)
Discussion started by: royzlife
7 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I am trying to run a shell script which contains an mkdir command as part of the execution. The script fails with the following error:
mkdir: cannot create directory `/builds/somedir/': Permission denied
The user running the script is 'harry' and belongs to group 'school'.... (5 Replies)
Discussion started by: Technext
5 Replies
4. UNIX and Linux Applications
Hi all,
I have a problem when I try to create a Directory Server on Directory Service Control Center - DSCC.
The log shows the following:
Creating Directory Server test1:389. Server Logs:
couldn't set locale correctly
couldn't set locale correctly
Directory '/var/ds/' already exists... (1 Reply)
Discussion started by: Yohanna Flores
1 Replies
5. Red Hat
for incompatibility installation problems, I've decided to reinstall Centos 6.3
as can be seem from the df output, I've partitioned both / and and /home directories
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda8 12G 5.3G 6.5G 45% /
tmpfs ... (2 Replies)
Discussion started by: jediwannabe
2 Replies
6. Shell Programming and Scripting
i need to give permission to ORACLE SERVER to create a directory in a particular path.
How to do it?Oracle server is installed in Unix (11 Replies)
Discussion started by: rafa_fed2
11 Replies
7. AIX
Hi.
My example:
I have a filesystem /log. Everyday, log files are copied to /log. I'd like to set owner and permission for files and directories in /log like that
chown -R log_adm /log/*
chmod -R 544 /log/*It's OK, but just at that time. When a new log file or new directory is created in /log,... (8 Replies)
Discussion started by: bobochacha29
8 Replies
8. Solaris
Hi All,
I have this file system /sys/app/ and application creating many file under that path.
I want any created file under that path to be created with 644 permission
Any help support in this please! (2 Replies)
Discussion started by: AbuAliiiiiiiiii
2 Replies
9. UNIX for Beginners Questions & Answers
Hello,
I am creating a file with all the source folders included in my git branch, when i grep for the used source, i found source included as relative path instead of absolute path, how can convert relative path to absolute path without changing directory to that folder and using readlink -f ? ... (4 Replies)
Discussion started by: Sekhar419
4 Replies
10. UNIX for Beginners Questions & Answers
What is the difference ../directory path and ./directory path in ksh? (1 Reply)
Discussion started by: TestKing
1 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::sqlanywhere5.18
DBIx::Class::Storage::DBI::SQLAnywhere(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::SQLAnywhere(3)
NAME
DBIx::Class::Storage::DBI::SQLAnywhere - Driver for SQL Anywhere
DESCRIPTION
This class implements autoincrements for SQL Anywhere and provides DBIx::Class::InflateColumn::DateTime support and support for the
"uniqueidentifier" type (via DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.)
You need the "DBD::SQLAnywhere" driver that comes with the SQL Anywhere distribution, NOT the one on CPAN. It is usually under a path such
as:
/opt/sqlanywhere11/sdk/perl
Recommended connect_info settings:
on_connect_call => 'datetime_setup'
METHODS
connect_call_datetime_setup
Used as:
on_connect_call => 'datetime_setup'
In connect_info to set the date and timestamp formats (as temporary options for the session) for use with
DBIx::Class::InflateColumn::DateTime.
The "TIMESTAMP" data type supports up to 6 digits after the decimal point for second precision. The full precision is used.
The "DATE" data type supposedly stores hours and minutes too, according to the documentation, but I could not get that to work. It seems to
only store the date.
You will need the DateTime::Format::Strptime module for inflation to work.
MAXIMUM CURSORS
A DBIx::Class application can use a lot of cursors, due to the usage of prepare_cached.
The default cursor maximum is 50, which can be a bit too low. This limit can be turned off (or increased) by the DBA by executing:
set option max_statement_count = 0
set option max_cursor_count = 0
Highly recommended.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::SQLAnywhere(3)