Is there a good way of dumping a table that contains LOB columns and importing it to another table? If yes, please let me know how.
There are a couple of ways. First, you can use the export/import utilities provided with Oracle. Just export the table into a dump file. Then, use import to import into another database. If both the source and destination tables are in the same instance, then you can just use an SQL commands to move the data as follows:
INSERT INTO dest_table SELECT * FROM source_table;Since the columns are LOBs and not LONGs, the above command will work.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.