473,387 Members | 1,863 Online

Home Posts Topics Members FAQ

home > topics > importing specific tables from a full export ?

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Importing specific tables from a full export ?

Can u import only specific user / non-system tables ( FULL=N ) from a
full export ( FULL=Y ) ?

Does it matter if the export was done on 64-bit Solaris SPARC and the
import will be done on an Intel box .. running Windows or Linux ?

FYI. Using 32-bit Oracle 8.1.7.4.0

Jul 19 '05 #1

Subscribe Post Reply

1

5539

Tim Cuthbertson

Yes, you can. Use the FROMUSER and TOUSER specifications and, oddly enough,
specify the tables you want with TABLES.

It shouldn't matter about the platforms. I have exported from HP-UX to Sun
Solaris and Windows NT.

Tim

"noone" <no***@noone.org> wrote in message
news:Cl********************@news-server.bigpond.net.au...

Can u import only specific user / non-system tables ( FULL=N ) from a
full export ( FULL=Y ) ?

Does it matter if the export was done on 64-bit Solaris SPARC and the
import will be done on an Intel box .. running Windows or Linux ?

FYI. Using 32-bit Oracle 8.1.7.4.0

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

importing DB from another SQL server

by: anguo | last post by:

Hello, I need to set up a development platform at home with a copy of a DB from a SQL server at a friend's company. So far, all my attempts at backup/restore or export/import have failed...

Microsoft SQL Server

Importing Access databases into SQL Server

by: boblotz2001 | last post by:

Hi there, I have a situation where an application needs to import data from number of access mdb files on a daily bases. The file names change every day. The data import is very straight...

Microsoft SQL Server

Importing from PL/SQL to MSSQL

by: The Fold | last post by:

Hi there, I've done some searching around on this subject and can't find anything helpful or non-expensive so far. I need to export some tables from my companies Oracle server locally so I...

Microsoft SQL Server

Exporting and Importing tasks to Task Center

by: klh | last post by:

We are running on Win 2003/DB2 V8 FP7a. My question concerns Task Center. I have about 200 tasks created and scheduled in Task Center. We are going to be moving many of the databases from this...

Standard Method for Importing/Exporting to DB

by: Snozz | last post by:

The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...

Visual Basic .NET

Exporting/Importing XML File

by: Mike Collins | last post by:

I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble...

Error importing xml file

by: Mike Collins | last post by:

I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble...

importing csv to datagrid, adding column data

by: JMO | last post by:

I can import a csv file with no problem. I can also add columns to the datagrid upon import. I want to be able to start importing at the 3rd row. This will pick up the headers necessary for the...

Importing specific tables from a full export ?

by: noone | last post by:

Can u import only specific user / non-system tables ( FULL=N ) from a full export ( FULL=Y ) ? Does it matter if the export was done on 64-bit Solaris SPARC and the import will be done on an...

Oracle Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!