• IMP / EXP statements from DOS prompt

    Hello All, EXP / IMP commands cannot be run from DOS prompt. The error message says that the command is not valid. Checking with Microsoft's website says that this is by design for systems that were upgraded to Windows 2000 from NT or 95. Could you suggest a surefire workaround for that? It's not...

    Baburamkumar0 pointsBadges:
  • Export/Import schemas

    I had this issue. Everytime a user resigns, i had to export his schemas and import it into another user who is taking over his duties. Q1: Can i use import/export utilities to specify different schemas under oracle 9.2.0? How? Q2: Do i need to give authority/? to allow the new user, user2, to use...

    Mayleong0 pointsBadges:
  • Implementing and configuring VPN Server

    Hello, Shiraz, I want to implement n configure VPN Server, so that my mobiles users and employee can access there file and network through Securely VPN Connection. Can any body help me out of this.. I need complete n detailed about VPN Configurations. What Hardware n software do i need to have...

    OnlineTechSupport0 pointsBadges:
  • Flashback query

    Background: Oracle 9.2.0 running on win2003 I have enabled UNTO_RETENTION = 36000 (10 hours). I executed the dbms package using userid = SYSTEM EXECUTE DBMS_FLASHBACK.ENABLE_AT_TIME(SYSDATE - 10/24); I got the error message "SYS.DBMS_FLASHBACK not enabled for user sys" Why is Oracle giving me this...

    Mayleong0 pointsBadges:
  • Installing Seperate Internet Connection for Managers

    Hello, Myself shiraz, I got one problem. There are Five Floor in one Office which has Switches COnneted to each floor. They are getting LAN and WAN Connection through Centralized Wireless Server Room. Also We have access point to get connectivity from Head Office, which is just near to us. And that...

    OnlineTechSupport0 pointsBadges:
  • Library management system

    i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse

    Eduado0 pointsBadges:
  • Querying GIS Data

    I have GIS dataset which i want to query for finding intersections. The data goes like this: ID Street1 Street2 Intersection 1 407 HWY 407 RAMP 407 HWY & 407 RAMP 2 407 HWY 410 HWY 407 HWY & 410 HWY 3 407 HWY 427 HWY 407 HWY & 427 HWY 5 407 RAMP 410 HWY 407 RAMP & 410 HWY 6 407 RAMP AIRPORT RD 407...

    RPandya0 pointsBadges:
  • Oracle Foreign Keys to Drop

    I have a problem where I need to drop certain tables and Create replacements (schema additions/deletions to the tables). Because I have Grandfather-Father-Son table type relationships I have Foreign Keys between them. I need to drop the Foreign Keys but if I build a script to SELECT "ALTER TABLE...

    NigelT0 pointsBadges:
  • Fields indexing

    Topic: SQL Question: My question is regarding fields indexing. My table named' K5Details' contains about 200,000 records and the response time to access this table is quite slow. What is the best way to index this table in order to get better response time To this table, I've created few indexes....

    Azizah0 pointsBadges:
  • Extracting SAP R3 data in custom DW

    We are in the process of building a custom data warehouse (SQL with Business Objects Universe for reporting) - this is continuing the existing company strategy. The difference this time is that we need to extract data from SAP R3 to feed into the warehouse. What I'm not sure about is the best...

    Jroth730 pointsBadges:
  • ASE Trigger

    select @command = 'INSERT INTO tablename SELECT * FROM inserted' execute(@command) Hi all, i am building a dynamic SQL Command inside a trigger, i received an error message that table inserted is not found. (i am using ASE 12.5.1) thanks,

    Ghassanhaith0 pointsBadges:
  • Data transfer Job

    I want to Import Data from SQLSERVER 2k into Oracle. Tell me the way to do it quickly.

    Sabyad0 pointsBadges:
  • Import utility in Oracle

    When importing a table (as a means of restoring), and specify ROWS = Y, does the data in the table get overridden?

    Mayleong0 pointsBadges:
  • Unable to create new records in other database using local form (writing background agent)

    Hi, I am trying to create an agent in a database that creates a new document in the local address book using its local form (Person). Debug shows that all is fine except that it does not save (the flag value is -1). What am I missing? Here is my code: Sub Initialize Dim s As NotesSession Dim...

    Arnaud660 pointsBadges:
  • Should you ever consider creating a fresh database for a user’s e-mail?

    On our Domino server, there is one mailbox that keeps generating errors. It is flagged in STATREP.nsf daily because documents can't be created or mail rules are problematic. I am unable to view the Rules in the database, and in Domino Administrator, it's the only mail file that doesn't show a...

    DKoch675 pointsBadges:
  • Configuring OEM to access Oracle on 2 systems

    Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP= oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP: OEM is configured on win2k (client platform--not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in...

    Mayleong0 pointsBadges:
  • Trying to solve ORA-00980: synonym translation is no longer valid

    I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...

    Aascotty0 pointsBadges:
  • time-based & change-based recovery

    i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now...

    Mayleong0 pointsBadges:
  • Tablespace recovery

    Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile (if...

    Mayleong0 pointsBadges:
  • SQL Server worst practices

    Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...

    Nbellistri0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.