Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: dumb question- can you backup only data from tables? DBA sez no

Re: dumb question- can you backup only data from tables? DBA sez no

From: Syltrem <>
Date: Thu, 11 Mar 2004 10:41:06 -0500
Message-ID: <gK%3c.983$>

With IMPort you can use ROWS=Y INDEXES=N IGNORE=Y TABLES=(list of tables to be loaded) CONSTRAINTS=N GRANTS=N

That will load the data in tables previously created with your "setup script".

It should not do anything else than that, if the tables already exist (otherwise it would create the tables with no indexes).

Have your DBA looked at any trace files or alert log in search of more info on the cause of the problem?
Has he tried tracing the application to see what it was trying to do at the time of the error?
It could have just been a problem with privileges. Running your "setup script" evidently took care of that. An EXPort/IMPort could not fix that.


OpenVMS 7.3-1 + Oracle (OpenVMS related web site, en français)
---zulu is not in my email address---
"D" <> a écrit dans le message de

> Long story short- I trusted our DBA to solve the problem and he threw
> up his hands:
> We have a client server app that connects to Oracle. For some reason
> we were getting more and more errors in the C/S app when connecting to
> data. No one here had the expertise to solve them, so we called in a
> consultant. Consultant resinstalled application and ran scripts which
> built the oracle 8i database. We took the export file of the original
> database, but every time our DBA imported it we got the same
> application errors. These were not oracle errors so I have no ORA
> numbers. We started again 3 times and each time during the import the
> data and our dba said- "the application is wrong, I give up."
> I created the instance one more time via the setup scripts. I
> painstakingly generated insert statements for all the data using TOAD
> and then ran those insert scripts into oracle via sqlplus. A real
> pain. Problem was solved in 2 hours and the C/S application works
> fine.
> It sounds to me like the export/import took information about the
> schema, users, roles, or in vague generalities- "data structure"
> outside of the data itself. When I imported just the data from the
> tables- no errors.
> I am no maintenance DBA, I design tables in oracle for use in
> applications. How could we have used our export file to just import
> the data and not other elements of the export file (users, schema,
> etc)? what did our DBA do wrong and what does it show about his
> skills or lack thereof? (I'm kind of pissed I had to take this over.)
> Thanks,
> Don
Received on Thu Mar 11 2004 - 09:41:06 CST

Original text of this message