Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bbanner

    How can I open an editor (vi,emacs) within a Tcl shell?

    I'm writing a command-line Tcl script, and I would like to open up a text editor (vi, emacs, etc.) to allow the user to enter formatted input. My initial attempt at this failed. Here's what I did: 1. created a unique temporary file name 2. used the "exec" command to open the unique...
  2. bbanner

    How do I export a table that has data > 2GB??

    Well, the problem is that no backup method has been implemented yet. Further, the system was hacked and we are unsure as to how the hackers got in (since we didn't build the system). The goal is to back everything up, wipe the disk and reinstall the OS, oracle, etc., then import the data. The...
  3. bbanner

    How do I export a table that has data > 2GB??

    I have to admit that I am a novice when it comes to Oracle DBA work... What exactly is required to "redesign the table to make it partitioned"? Would that mean creating a new partitioned table and then selecting into it? Or are there ways to modify the existing table's structure in...
  4. bbanner

    How do I export a table that has data > 2GB??

    I recently inherited a database that I need to backup/export. There is one table with ~36 million records, each ~8000 bytes worth of data. So, I've found I can't use the exp utility to export the data since the resultant file is bigger than 2GB. Unfortunately, I don't think the table was...
  5. bbanner

    Query Performance on Large Tables (15 million records)

    Background: 1) I have a table that has 15.1 million records in it. 2) This is my first experience with Oracle, though I've used other database systems (mostly MySQL). 3) I currently have little knowledge of the actual hardware that Oracle is running on as I just replaced the person who set it...

Part and Inventory Search

Back
Top