Search results for query: *

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...

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...

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...

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...

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...