Search 5,000,000+ questions and answers.

Frequently Asked Questions

When would I use SQL*Loader instead of Data Pump Export and Import?

Oracle Data Pump FAQ
You would use SQL*Loader to load data from external files into tables of an Oracle database. Many customers use SQL*Loader on a daily basis to load files (e.g. financial feeds) into their databases. Data Pump Export and Import may be used less frequently, but for very important tasks, such as migrating between platforms, moving data between development, test, and production databases, logical database backup, and for application deployment throughout a corporation.
Related Questions

When would I use Transportable Tablespaces instead of Data Pump Export and Import?

Oracle Data Pump FAQ
You would use Transportable Tablespaces when you want to move an entire tablespace of data from one Oracle database to another. Transportable Tablespaces allows Oracle data files to be unplugged from a database, moved or copied to another location, and then plugged into another database.
Related Questions

What about command line tools like SQL*Loader, Import, Export, utilities?

A Detailed Look at the NLS_LANG Parameter
Typically the NLS_LANG needs to match the MS-DOS OEM code page that could be retrieved by typing chcp in a Command Prompt: For tools like SQL*Loader you can temporarily change the NLS_LANG to the character set of the FILE you are loading. An alternative to changing NLS_LANG is to specify the character set of the data in the datafile using the characterset keyword in the .ctl file.
Related Questions

Can I monitor a Data Pump Export or Import job while the job is in progress?

Oracle Data Pump FAQ
Yes, jobs can be monitored from any location is going on. Clients may also detach from an executing job without affecting it.
Related Questions

Can I still use Original Export? Do I have to convert to Data Pump Export?

Oracle Data Pump FAQ
Oracle9i compatible Export that operates against Oracle Database 11g will ship with Oracle 11g, but it does not export Oracle Database 11g features. Also, Data Pump Export has new syntax and a new client executable, so Original Export scripts will need to change. Oracle recommends that customers convert to use the Oracle Data Pump Export. Original Import will be maintained and shipped forever, so that Oracle Version 5.
Related Questions

Can I import and/or export ProblemTracker data?

NetResults ProblemTracker FAQ for Web-based bug tracking, ch...
Yes, ProblemTracker supports export of a ProblemTracker database in CSV format (ASCII comma separated data). However, importing legacy data (data from a system other than ProblemTracker) into a ProblemTracker database directly, as opposed to entering it via the web interface, is a task that requires the use of the ProblemTracker Software Development Kit (SDK), an add-on option of ProblemTracker, or requires the assistance of NetResults Professional Services department.
Related Questions

Can I import and export data?

Faq- IT Help Desk Software Solutions, Helpdesk Call Tracking...
Yes, SupportDesk has both importing and exporting functionality. Data can be exported from the Database menu, choose Export CSV File. You are then presented with a choice of record types to export, or you may select All. Records are exported in CSV (Comma Separate Value) format, to a flat text file. Similarly, data can be imported into SupportDesk in a similar file format. Thus allowing you to swiftly populate the SupportDesk database with data held elsewhere.
Related Questions

How do I import and export model data?

FAQs about supply chain guru : LLamasoft
Your model data can easily be imported and exported from Microsoft Excel, and all models can be opened directly in Microsoft Access. To export from Supply Chain Guru to an Excel spreadsheet, simply open the table that you wish to export, and choose the "Export current grid to Excel" button on the toolbar. An Excel spreadsheet automatically opens. Make any desired changes to the data.
Related Questions

Can I import/export existing data?

CMMS Software - COGZ Systems General Questions
Importing can be accomplished using the built-in COGZ import/export utility that allows you to map our data fields and import your data via common text files.
Related Questions

What is the difference between the Export/Import functions in STUDIO and SQL Manager for SQL Server?

SQL Manager | EMS SQL Management Studio for SQL Server | Pro...
The Export/Import tools in STUDIO includes additional features, which are not available in SQL Manager for SQL Server.
Related Questions

How do I use Import / Export?

MLMPro* - Frequently Asked Questions
The Import item of the File Menu allows you to import contacts from a comma delimited file created by some other database program. Export creates comma delimited files from the contacts in your MLMPro* database for use with other programs. For more detailed information, see the MLMPro* Help File.
Related Questions

Can I import/export data to/from NetDoc?

NetDoc Cable Management Software Frequently Asked Questions
NetDoc ships with a developed excel import tool for your use. This tool is formatted and built to confirm to the NetDoc SQL database tables so an import will automatically populate the proper tables. NetDoc databases are ODBC compliant. That means any other data source that is ODBC compliant can be linked to the NetDoc database. A professional database person will be needed to create these links if possible. This is not an automatic feature.
Related Questions

Can I export/import QuickBooks data?

QuickBooks Frequently Asked Questions - Call 800-259-4213
To move an entire data file from one computer to another, you can back your data file to floppy disk(s) and restore it to another computer. To do this, click on File, Backup or File, Restore. All the information contained within any QuickBooks report can be exported to a Text (ASCII), Excel or tab delimited file. To do this, create the required report, then click Print, and choose the required destination and format. Most information contained within a List can be exported.
Related Questions

Can I import/export model data from/to other tools?

UML Modeling Tool - JUDE
Using JUDE Collaboration with JUDE/Server brings a valued facilitation for Team Development by integrating projects using repository to share models among development team members. Yes. You can merge project files that are created with JUDE/Community using JUDE/Professional. ( [File] - [Merge Project]) Please make sure that you use the same or higher model version of JUDE/Professional to merge with. Go to http://jude.change-vision.com/jude-web/download/document.
Related Questions

How do I import/export data/reports from/to Excel?

FAQ about apm
From "APM" you can export reports to text files, then you can convert these files to the Excel format from Excel. To import ".txt" or ".xls" files in to ".apm" files you need the special utility.
Related Questions

What types of data import and export are available?

Peake Software. Manage Your Schedule. Anytime. Anywhere. Via...
Peake Software Labs will provide a customized import routine to load existing Provider information from compatible data source. This service is included as part of the installation setup if the Tangier Enterprise client commits to an annual support contract. Otherwise, the service is available at the time and materials rate of $100.00 per hour for non-support contract and Professional clients. Tangier? Professional and Enterprise have a variety of support options and training packages.
Related Questions

Can I Import/Export Data to and from Squash 'Em?

Desertware - FAQ
Import/Export utility is currently being worked on and will be released in a future upgrade to Squash 'Em. If you currently have data you need imported right away we can do the import work for you. Contact dwsales@desertware.com to learn more.
Related Questions

Can I export and import data from MS Excel?

Inspection Management Software, RBI Software, Corrosion Soft...
Yes. Most Credo data can be exported into Excel, Word or Adobe PDF format. You can also create your own custom report templates. As an alternative to using Dataloggers you export thickness inspection data to Excel and then after the survey has been completed you can import the thickness readings back into Credo. Excel is an ideal medium if you are using a third party inspection team to carry out your inspection activities.
Related Questions

Can I import and/or export NetResults Tracker data?

NetResults Tracker FAQ -- Web-based Bug Tracking, Workflow/C...
Yes, NetResults Tracker supports export of a NetResults Tracker data in CSV format (ASCII comma separated data). The export option is available for all reports (Query, Metrics, History).
Related Questions

Can I import and export data between SendStudio and another application?

Email Marketing Solutions and Email Marketing Software - Sen...
Yes, SendStudio allows you to import subscribers using CSV files and to also export your subscribers also in CSV format. In the 'Subscribers' drop down menu, you will see the option to "Import Sub ...
Related Questions

What about data import and export utilities ?

Interactive Net Mapping Limited
It is recognised that some companies may have a wealth of existing data that simply cannot be keyed in directly by hand. The initial premise for "oilelefant" was to create a simple system for a limited number of wells, licence blocks and a few hundred seismic lines, which involves a minimal data entry effort and the main data can be updated within a few days, forming the initial foundation and basis for adding additional data interactively.
Related Questions

What is the performance gain of Data Pump Export versus Original Export?

Oracle Data Pump FAQ
Using the Direct Path method of unloading, a single stream of data unload is about 2 times faster than original Export because the Direct Path API has been modified to be even more efficient. Depending on the level of parallelism, the level of improvement can be much more.
Related Questions

What is the performance gain of Data Pump Import versus Original Import?

Oracle Data Pump FAQ
A single stream of data load is 15-45 times faster Original Import. The reason it is so much faster is that Conventional Import uses only conventional mode inserts, whereas Data Pump Import uses the Direct Path method of loading. As with Export, the job can be parallelized for even more improvement. No, Data Pump requires no special tuning. It runs optimally “out of the box”. Original Export and (especially) Import require careful tuning to achieve optimum results.
Related Questions

How do you use the Import/Export option in CASST?

CASST, Computer Aided Septic System Tracking Software, Frequ...
The Import/Export feature from the "Tools" pull-down menu is to be used between CASST programs to transfer completed inspection reports from one program to the other. For a more complete explanation of how to use this feature, see the document: "How to Use Import-Export". Two versions of this document are available. quot;How to Use Import-Export" as a PDF document. (The Acrobat Reader® is required, click to download it from their web site.)
Related Questions

Can we export our data to use in another program?

Volunteer Software - volunteer2 - FAQs for web based Volunte...
You can currently export all contact information from the software into a spreadsheet. In the next release, contact information can be exported into a spreadsheet or v-card (for Microsoft Outlook™) and volunteer tracking reports can be exported into spreadsheets, pdfs,or html and charts can be exported in image files.
Related Questions

I have a front loader or High Efficiency washer. What detergent should I use?

Fuzzi Bunz FAQ, Troubleshooting, Warranty Information and Ca...
Any washing detergent recommended by Fuzzi Bunz should be adequate; however using 1/6 of the recommended amount is required for a front loader. If there are too many suds, reduce your amount of liquid, if the diapers are not getting clean enough, increase your liquid.
Related Questions

Fuzzi Bunz Frequently Asked Questions
Any washing detergent recommended by Fuzzi Bunz should be adequate. Use 1/6 of the recommended amount for a front loader. If there are too many suds, reduce your amount of liquid. If the diapers are not getting clean enough, increase your liquid.
Related Questions

Got A Question? Ask Our Community!


More Questions >>

© Copyright 2007-2008 QueryCAT
About • Webmasters • Contact