05-16-2014
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a script which gives the output of schemas in Oracle DB :
#!/bin/ksh
ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL
do
if ; then
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:.
... (0 Replies)
Discussion started by: run_time_error
0 Replies
2. UNIX and Linux Applications
Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue (0 Replies)
Discussion started by: girija
0 Replies
3. UNIX for Dummies Questions & Answers
Hi...
I have dump in unix machine...How can I this import dump to Oracle database?
Many thanks in advance. (2 Replies)
Discussion started by: agarwal
2 Replies
4. Emergency UNIX and Linux Support
Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue..
I need it asap thats y posted here
Thanks (5 Replies)
Discussion started by: girija
5 Replies
5. Shell Programming and Scripting
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I need to import more than 250K of records to another Database(Oracle).But I want particular column value to be changed in the destination table. Is it possible to do this during export or import process with out modifying data from original table.I do not want to run Update manually.
... (6 Replies)
Discussion started by: GOVINDARAJ.M
6 Replies
7. UNIX and Linux Applications
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies
8. UNIX and Linux Applications
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Discussion started by: clerck
2 Replies
9. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
are the oracle dump files compatible to direct import into db2?
I already tried many times but it always truncated results.
anyone can help/ advice or suggest?
2. Relevant commands, code, scripts, algorithms:
exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
LEARN ABOUT PHP
datefmt_get_timezone_id
DATEFMT_GET_TIMEZONE_ID(3) 1 DATEFMT_GET_TIMEZONE_ID(3)
IntlDateFormatter::getTimeZoneId - Get the timezone-id used for the IntlDateFormatter
Object oriented style
SYNOPSIS
public string IntlDateFormatter::getTimeZoneId (void )
DESCRIPTION
Procedural style
string datefmt_get_timezone_id (IntlDateFormatter $fmt)
Get the timezone-id used for the IntlDateFormatter.
PARAMETERS
o $fmt
- The formatter resource.
RETURN VALUES
ID string for the time zone used by this formatter.
EXAMPLES
Example #1
datefmt_get_timezone_id(3) example
<?php
$fmt = datefmt_create(
'en_US',
IntlDateFormatter::FULL,
IntlDateFormatter::FULL,
'America/Los_Angeles',
IntlDateFormatter::GREGORIAN
);
echo 'timezone_id of the formatter is : ' . datefmt_get_timezone_id($fmt);
datefmt_set_timezone_id($fmt, 'CN');
echo 'Now timezone_id of the formatter is : ' . datefmt_get_timezone_id($fmt);
?>
Example #2
OO example
<?php
$fmt = new IntlDateFormatter(
'en_US',
IntlDateFormatter::FULL,
IntlDateFormatter::FULL,
'America/Los_Angeles',
IntlDateFormatter::GREGORIAN
);
echo 'timezone_id of the formatter is : ' . $fmt->getTimezoneId();
$fmt->setTimezoneId('CN');
echo 'Now timezone_id of the formatter is : ' . $fmt->getTimezoneId();
?>
The above example will output:
timezone_id of the formatter is : America/Los_Angeles
Now timezone_id of the formatter is : CN
SEE ALSO
datefmt_set_timezone_id(3), datefmt_create(3).
PHP Documentation Group DATEFMT_GET_TIMEZONE_ID(3)