How to exp a single table from Ora8174 1

[coroner74]

Hi,
I'm not familiar with Oracle sql commands also to the syntax of the exp-tool but need to export a single
table to a text-file on solaris.
I'm struggling with the syntax what table I want to export...
My current commandline reads:
/oracle/P22/bin/exp system/xxxx file=/oracle/P22/sapbackup/DBSTATC.EXP
log=/oracle/P22/sapbackup/DBSTATC.LOG tables=(sapr3.dbstatc) volsize=0
and I receive a
"Badly placed ()'s"

Thanx in advance.
Coroner74

 

[alexhu]

You don't need volsize =0. In fact I don't know why you have this parameter at all ?

VOLSIZE
Specifies the maximum number of bytes in an export file on each volume of tape

Otherwise it looks Ok to me

this is from the utilities manual

exp SYSTEM/password FILE=expdat.dmp TABLES=(scott.emp,blake.dept) GRANTS=y-
INDEXES=y


Alex

 

[sem]

You should omit parenthesis for single value.
Call exp -help for command description.

Regards, Dima

 

[sybaseguru]

Coroner,

on Unix platforms the bracket "(" is treated differently in the shell. Yours should work but prefix "(" with "\("

oracle@linux:/home/oracle% exp system file=/tmp/abc.dmp log=/tmp/abc.log tables=\(scott.emp,student.student\) volsize=0

Export: Release 9.2.0.1.0 - Production on Wed Jul 9 12:55:30 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to SCOTT
. . exporting table                            EMP         14 rows exported
Current user changed to STUDENT
. . exporting table                        STUDENT        273 rows exported
Export terminated successfully without warnings.

good luck

 

[coroner74]

Thanks to you sybaseguru.
This works great.

coroner74