Copying a LONG RAW column into another tablespace

How can I copy a table with a LONG RAW column from one into another tablespace? It´s important to know that it is not allowed to change the LONG RAW datatype.

Published: 14 Sep 2005

How can I copy a table with a LONG RAW column from one into another tablespace? It´s important to know that it is not allowed to change the LONG RAW datatype.

Since you are using the LONG RAW datatype, your only option to move the table to another tablespace is to use the export and import utilities.

First, dump the table's contents to a dump file:

exp userid=system/manager file=move.dmp tables=scott.emp

Use the correct table name above. Next, drop the table and recreate it in the correct tablespace. Once the table is recreated, import the dump file contents with the IGNORE=Y option.

imp userid=system/manager file=move.dmp tables=scott.emp ignore=y

Dig Deeper on Oracle database design and architecture

SearchDataManagement

MongoDB Atlas now enables multi-cloud database clusters

Multi-cloud data portability comes to MongoDB Atlas with a new capability that will enable users to run a database application ...

How AI data privacy can help your enterprise

Enterprises benefit in many ways from AI data privacy tools that reduce the need for manual efforts from data professionals. Read...

The new normal for enterprise data governance

Mastercard data exec highlights the foundational role of enterprise data governance during the pandemic era with more people ...

SearchBusinessAnalytics

Logi Analytics keeps focus on embedded app development

Kevin Greene is the new CEO of Logi Analytics after previously serving as the vendor's COO. In an interview, Greene discusses his...

Data literacy skills key to cost savings, revenue growth

As organizations develop data-driven cultures, they need to implement programs to teach employees how to work with and make ...

Yellowfin 9.3 features embedded app development upgrades

New application programming interfaces to help app designers build embedded BI apps are among more than 25 new features in the ...

SearchSAP

Decide on SAP S/4HANA Cloud: Single-tenant vs. multi-tenant edition

Understanding the benefits and limitations of S/4HANA Cloud versions is essential to making the right choice. Here are some ...

How 2 S/4HANA projects wrapped up remotely due to COVID-19

Here's how two SAP S/4HANA migration projects by De Nora Group and Vistaprint were completed on time after the COVID-19 crisis ...

Wookey returns to SAP to head Intelligent Spend unit

Industry veteran John Wookey is back at SAP to run the newly formed SAP Intelligent Spend and Business Network as SAP Ariba ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

3 ways to implement AI in software development

Further advancements to AI make it a more appealing and useful option for enterprise software development. Here are three ways to...

5 helpful tips to reduce webpage load time, improve performance

Nobody wants to wait for a webpage to load. Follow these tips to reduce website load time and improve the user experience for a ...

Is Apache Tomcat the right Java application server for you?

What is the best application server? The answer depends on what an enterprise is looking for. Compare Apache Tomcat to these four...

SearchDataCenter

IBM cloud revenues climb as hardware continues to decline

IBM cloud revenues continue to increase as hardware sales drop, sharpening the company's strategy to focus on hybrid cloud.

Figure out the differences of asset management vs. CMDB

There is no shortage of software options for change management tools. Operational goals can help IT teams decide if ITAM or CMDB ...

IBM partners with HBCUs to promote quantum computing

IBM is partnering with a group of historically Black colleges and universities to set up a quantum computing center in hopes of ...

SearchContentManagement

Choosing the right collaboration suite for business

Collaboration suites are an essential component of remote work, enabling teamwork throughout a distributed enterprise. Decide ...

Acquia Drupal, Marketing Cloud get feature boosts

Acquia users get Drupal migration tools and marketing automation features built with technology from recent acquisitions as the ...

How automated content tagging improves findability

Companies that use AI to automatically tag their metadata can improve findability of content across the entire organization. AI ...

SearchHRSoftware

Tensions over politics at work have HR on guard

Politics at work may hurt productivity and office harmony. One strategy for defusing a charged atmosphere may be to get employees...

Top 9 tech skills HR professionals need for success

Today's HR departments are increasingly reliant on a range of technologies. That means human resources professionals must get ...

As contingent employee hiring rises, HR gives it focus

The use of contingent employees is increasing, Gartner said, and with it an interest from HR departments for better control over ...

Dig Deeper on Oracle database design and architecture

Query Tuning for Developer, Beginner DBAs

Copy Oracle Database but with no data

Import on one table from dump file

How to export data by date in Oracle

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.