02-05-2004
Hi,
The exp and imp commands are pretty much the same on unix or windows...
To do a full export:
( the user can be any user with DBA role )
exp SYSTEM/passwd FULL=y FILE=database_export.dmp GRANTS=y ROWS=y
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Could someone give me a hint how to get or write such a job ?
I want to schedule a Oracle export using the crontab, I really do not know how to do this.
Concreet: How do I write such a script ?
Thanks for your help. (1 Reply)
Discussion started by: c.d.israel
1 Replies
2. UNIX for Advanced & Expert Users
How can we export a file in unix with certain number of columns to an excel sheet.
It's very useful in time saving...... (3 Replies)
Discussion started by: bishweshwar
3 Replies
3. Shell Programming and Scripting
Hi ,
Can anyone help me regarding loading a unix file data to oracle database table using shell scripts?
I wanted to grep only this data from a spool file
sql_test.txt
99
00:00:00:01
but if I use grep I am getting format
sql_test.txt
99 rows selected.
Elapsed:... (2 Replies)
Discussion started by: ran16
2 Replies
4. UNIX for Advanced & Expert Users
I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting...... (1 Reply)
Discussion started by: vidyadhar85
1 Replies
5. UNIX for Dummies Questions & Answers
I was able to convert my csv file in Unix to xls. I would like to export the converted xls file to a windows environment. I have to manually connect using the following below:
ftp: 192.x.x.x -> username/pass -> cd -> mget *.xls and then confirm.
Could I automate this process into a shell... (4 Replies)
Discussion started by: ravzter
4 Replies
6. Shell Programming and Scripting
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies
7. Shell Programming and Scripting
Hi All,
Is it possible to have AutoFilter applied in the Excel Sheet which is Exported from UNix server as *.csv file. (0 Replies)
Discussion started by: rawat_me01
0 Replies
8. UNIX Desktop Questions & Answers
Hi, everybody!
I have a big problem. I don't understand Unix, but I work as a system administrator, and sometimes I make some data exports and I have to delete old .dmp files, but today I had a mistake, I wrote rm * 909*
This is a part of my folder contents in unix before deleting
drwxrwxr-x 2... (4 Replies)
Discussion started by: susan12
4 Replies
9. Shell Programming and Scripting
dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies
10. Shell Programming and Scripting
hi all,
I have flat file in unix. By using sql loader i need to import the data from the flat file. I have created a control file, table with the below data structure and pasted the sample input file. I am not sure whether it is a right way to do it. can anyone provide the thought on this.
... (2 Replies)
Discussion started by: arun888
2 Replies
POW(3) 1 POW(3)
pow - Exponential expression
SYNOPSIS
number pow (number $base, number $exp)
DESCRIPTION
Returns $base raised to the power of $exp.
Note
In PHP 5.6 onwards, you may prefer to use the ** operator.
PARAMETERS
o $base
- The base to use
o $exp
- The exponent
RETURN VALUES
$base raised to the power of $exp. If both arguments are non-negative integers and the result can be represented as an integer, the result
will be returned with integer type, otherwise it will be returned as a float.
EXAMPLES
Example #1
Some examples of pow(3)
<?php
var_dump(pow(2, 8)); // int(256)
echo pow(-1, 20); // 1
echo pow(0, 0); // 1
echo pow(-1, 5.5); // PHP >4.0.6 NAN
echo pow(-1, 5.5); // PHP <=4.0.6 1.#IND
?>
NOTES
Note
This function will convert all input to a number, even non-scalar values, which could lead to weird results.
SEE ALSO
exp(3), sqrt(3), bcpow(3), gmp_pow(3).
PHP Documentation Group POW(3)