TABLEEXTRACT TABLE PAGEVIEWS OUTFILE pageviews.data
Here is the reply:
[EMAIL PROTECTED] mfoulk]# /opt/sapdb/depend/bin/repmcli -u dsa,admin -d iceburg -b /home/mfoulk/command.dat
Opened connection to Loader SERVER at node local host.
Loader Server Protocol File: '/var/opt/sapdb/indep_data/wrk/loader.prt'
User DSA connected to database ICEBURG on local host. TABLEEXTRACT TABLE PAGEVIEWS OUTFILE pageviews.data' Error during execution -->-25281 Syntax error at position 30 (Unexpected keyword: OUTFILE).
Defined maximum number of errors (1) reached
1 error(s) during execution of command file '/home/mfoulk/command.dat'. ---> See log file(s) for more information.
Some error(s) occurred running command. ---> See log file(s) for more information.
Does anyone know why this is happening.
Noah J SILVA wrote:
Hi,
What you want is the Replication Manager (7.3.x) or the Data Loader (7.4.x). This can export a table or view and also a command needed to re-import it. ( I don't know that it will make a "create table" statement for you though)
Thank you, Noah Silva IS&T - Programmer Analyst (215) 419 - 7916
David Barcelo <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/25/2003 12:39 PM
To: [EMAIL PROTECTED]
cc: Subject: Backing up certain tables...
My co-worker wants to backup certain tables and keep others out of the backup. We want to retain table structure and data. Is there a facility to dump tables.
Thanks in advance, Dave
-- _____
James David Barcelo Network/Systems Administration
Data Junction Corporation
2201 Northland Drive
Austin, TX 78756
tel: 512-459-1308 ext. 349
fax: 512-469-1309
www.datajunction.com
* The contents and attachments in this email are confidential.
_____
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
