Oracle EXP :: table export :: without triggers

From: Jetlag <jetlag11235_at_yahoo.com>
Date: 3 Apr 2003 09:29:07 -0800
Message-ID: <2eeed00e.0304030929.392aa21c_at_posting.google.com>

I am using Oracle 8i (8.1.6.1.0) on the Potato distribution of Debian Linux with a custom compiled kernel (2.2.19).

I would like to use exp to backup (only) the data in a single table. I have been unable to do this without grabbing the trigger associated with the table as well. Code snippets included below. This has been driving me nuts all morning. Any thoughts? Thanks.

• jetlag --

  ---

exp my_user/my_pass BUFFER=1000000 FILE=my_dump.dmp TABLES=raw_sgf INDEXES=N CONSTRAINTS=N GRANTS=N TRIGGERS=N STATISTICS=none QUERY=\"WHERE my_col \= 11\"

<lots of normal text here>

Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                        RAW_SGF      33138 rows

exported
Export terminated successfully without warnings.

---

imp other_user/my_pass BUFFER=1000000 FULL=y IGNORE=y FILE=my_dump.dmp

<lots of normal text here>

IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "DTW".RAW_SGF_INS_ROW_TRG"
" BEFORE INSERT ON RAW_SGF"
" FOR EACH ROW"
""
"DECLARE"
"BEGIN"
" :NEW.SEQ := 0;"
""
"END RAW_SGF_INS_ROW_TRG;"

Import terminated successfully with warnings. Received on Thu Apr 03 2003 - 19:29:07 CEST