Sponsored Content
Operating Systems Solaris exporting a dmp file (oracle)from unix Post 47211 by jsilva on Thursday 5th of February 2004 05:55:58 AM
Old 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

Crontab job for exporting a Oracle database

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

Exporting files from unix to Excel sheet

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

unix file to oracle table

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

How can i pass a file from unix to oracle??

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

Exporting Files from Unix to a Windows Platform

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

Exporting data as a CSV file from Unix shell script

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

AutoFilter in Excel report when exporting from Unix

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

Problem with deleting .dmp file

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

Scripts for exporting backup from selected tables of Oracle DB

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

File read from UNIX to Oracle

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
FREXP(P)						     POSIX Programmer's Manual							  FREXP(P)

NAME
frexp, frexpf, frexpl - extract mantissa and exponent from a double precision number SYNOPSIS
#include <math.h> double frexp(double num, int *exp); float frexpf(float num, int *exp); long double frexpl(long double num, int *exp); DESCRIPTION
These functions shall break a floating-point number num into a normalized fraction and an integral power of 2. The integer exponent shall be stored in the int object pointed to by exp. RETURN VALUE
For finite arguments, these functions shall return the value x, such that x has a magnitude in the interval [0.5,1) or 0, and num equals x times 2 raised to the power *exp. If num is NaN, a NaN shall be returned, and the value of *exp is unspecified. If num is +-0, +-0 shall be returned, and the value of *exp shall be 0. If num is +-Inf, num shall be returned, and the value of *exp is unspecified. ERRORS
No errors are defined. The following sections are informative. EXAMPLES
None. APPLICATION USAGE
None. RATIONALE
None. FUTURE DIRECTIONS
None. SEE ALSO
isnan() , ldexp() , modf() , the Base Definitions volume of IEEE Std 1003.1-2001, <math.h> COPYRIGHT
Portions of this text are reprinted and reproduced in electronic form from IEEE Std 1003.1, 2003 Edition, Standard for Information Technol- ogy -- Portable Operating System Interface (POSIX), The Open Group Base Specifications Issue 6, Copyright (C) 2001-2003 by the Institute of Electrical and Electronics Engineers, Inc and The Open Group. In the event of any discrepancy between this version and the original IEEE and The Open Group Standard, the original IEEE and The Open Group Standard is the referee document. The original Standard can be obtained online at http://www.opengroup.org/unix/online.html . IEEE
/The Open Group 2003 FREXP(P)
All times are GMT -4. The time now is 04:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy